https://community.jmp.com/t5/Discussions/convert-day-of-week-from-date-string/m-p/1417#M1417 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 --&gt; Num) will do that for you. Your formula will look like:<BR />Day Of Week( Num( :Column 1 ) ) Mon, 01 Mar 2010 22:46:39 GMT Anonymous 2010-03-01T22:46:39Z https://community.jmp.com/t5/Discussions/convert-day-of-week-from-date-string/m-p/1416#M1416 Hello,<BR /><BR />Newbie question.<BR /><BR />I have the following date string 14-Jan-2010 and I would like to get the day of week <BR />from this string. Should I use the formula editor or write a script.<BR /><BR />I tried using the he formula editor "day of week" but I get an error. <BR />The error might have to do with the format of the date string. <BR /><BR />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...<BR /><BR />Does anyone have a script to do this? Or formula?<BR /><BR />Thanks in advance. Mon, 01 Mar 2010 20:16:25 GMT https://community.jmp.com/t5/Discussions/convert-day-of-week-from-date-string/m-p/1416#M1416 MaryLoveless 2010-03-01T20:16:25Z https://community.jmp.com/t5/Discussions/convert-day-of-week-from-date-string/m-p/1417#M1417 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 --&gt; Num) will do that for you. Your formula will look like:<BR />Day Of Week( Num( :Column 1 ) ) Mon, 01 Mar 2010 22:46:39 GMT https://community.jmp.com/t5/Discussions/convert-day-of-week-from-date-string/m-p/1417#M1417 Anonymous 2010-03-01T22:46:39Z