cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the 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!!