cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
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!!