cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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
MaryLoveless
Staff MaryLoveless
Staff

convert day of week from date string

Mar 1, 2010 03:16 PM (9946 views)
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.
0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
Solution

Re: convert day of week from date string

Mar 1, 2010 05:46 PM (11049 views)  |  Posted in reply to message from MaryLoveless 03-01-2010
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

0 Kudos
1 REPLY 1
Solution

Re: convert day of week from date string

Mar 1, 2010 05:46 PM (11050 views)  |  Posted in reply to message from MaryLoveless 03-01-2010
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 ) )
0 Kudos