Convert data format

[yichentian226]

I'm working on a job and need to convert a character (for example: 05OCT2020) to "mmddyyyy" format  (for example: 10/05/2020)in the table. Still a beginner look forward to hearing any solutions/suggestions! Thanks.

[Kurt_Bremser]

date = input(chardate,date9.);
format date mmddyy10.;

[Reeza]

Is your variable type actually a character or is it displayed in that format but the type is numeric?

If it's a character, use Kurts solution, if its numeric just use the format statement, not the INPUT() statement.