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

convert day of week from date string

Hello,

Newbie question.

I have the following date string 14-Jan-2010 and I would like to get the day of week
from this string. Should I use the formula editor or write a script.

I tried using the he formula editor "day of week" but I get an error.
The error might have to do with the format of the date string.

I think I need to parse the string and then determine what day of the week it is i.e. Sunday (or 1), Monday (or 2) etc...

Does anyone have a script to do this? Or formula?

Thanks in advance.
1 ACCEPTED SOLUTION

Accepted Solutions

Re: convert day of week from date string

Fortunately, JMP can automatically read the date format: 14-Jan-2010. But it needs to be converted to a number first. The num() function (Character --> Num) will do that for you. Your formula will look like:
Day Of Week( Num( :Column 1 ) )

View solution in original post

1 REPLY 1

Re: convert day of week from date string

Fortunately, JMP can automatically read the date format: 14-Jan-2010. But it needs to be converted to a number first. The num() function (Character --> Num) will do that for you. Your formula will look like:
Day Of Week( Num( :Column 1 ) )