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!
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.
