cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Due to inclement weather, JMP support response times may be slower than usual during the week of January 26.
    To submit a request for support, please send email to support@jmp.com.
    We appreciate your patience at this time.
  • Register to see how to import and prepare Excel data on Jan. 30 from 2 to 3 p.m. ET.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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!!

Recommended Articles