cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
gow
gow
Level I

can i convert date mm/dd/yyyy to character "mmddyyyy"

I need to concat the date information with the file name, however during concat the date variable changes to sas or hexadecimal format. Thanks Gowri

2 REPLIES 2
pmroz
Super User

Re: can i convert date mm/dd/yyyy to character "mmddyyyy"

Use the Format statement to convert to text:

a = today();

b = format(a, "mmddyyyy");

print(b);

Yields the result:

"05232012"

gow
gow
Level I

Re: can i convert date mm/dd/yyyy to character "mmddyyyy"

thanks, This was exactly what i was looking for!!