topic How to calculate using JMP script "Mon-Day-Year Calculated" column from a character variable in Discussions

How to calculate using JMP script "Mon-Day-Year Calculated" column from a character variable

dfusco923 — Fri, 09 Jun 2023 22:05:27 GMT

I would like develop a JMP script to automatically calculate and populate the "Mon-Day-Year Calculated" column in the attached JMP database. In the database I manually calculated and populated the "Mon-Day-Year Manually Calculated and Entered" column. The "K9-MON_Year" character variable would be used to automatically calculate "Mon-Day-Year Calculated" data. Please note that I would like all "Days" = 15 . Also see the attached PowerPoint. Thanks in advance!

Re: How to calculate using JMP script "Mon-Day-Year Calculated" column from a character variable

Georg — Sun, 07 Feb 2021 07:30:38 GMT

I'm not sure whether I got you right, to calculate the date from the string I would use following formula:

Date DMY( 1, Num( Word( 2, :K9_MON_YEAR, "/" ) ), Num( Word( 3, :K9_MON_YEAR, "/" )

Here I placed a fixed Day=1 into the formula, I did'nt know where to get the information about day from. Maybe you can change according to your needs.

Re: How to calculate using JMP script "Mon-Day-Year Calculated" column from a character variable

dfusco923 — Tue, 09 Feb 2021 00:55:16 GMT

Thanks Georg - This is very close to what I am looking for except I would like the format to be m/d/y. Also I would like the "d" value to be 15.

Can you recommend the JMP script for that?

Re: How to calculate using JMP script "Mon-Day-Year Calculated" column from a character variable

txnelson — Tue, 09 Feb 2021 03:34:02 GMT

All you need to do to change @Georg formula to output the 15th day instead of the 1st day, is to change the Day parameter passed to the Date DMY() function. This would be the first parameter, as indicated in the name of the function. As can be seen in @Georg formula, the value is "1". Just change it to 15.

The changing of the display format to m/d/y, what needs to be done, is to go to the Column Info dialog box(right click on the column header and select Column Info), and in that dialog, change the format to the m/d/y format.

Documentation on JMP date time columns is covered in the JMP Document called Using JMP. It can be found in the JMP Documentation Library, available under the Help pull down menu.

Re: How to calculate using JMP script "Mon-Day-Year Calculated" column from a character variable

dfusco923 — Wed, 10 Feb 2021 14:41:05 GMT

Thanks for the help.