topic Re: How to calculate date from cumulative data? in Discussions https://community.jmp.com/t5/Discussions/How-to-calculate-date-from-cumulative-data/m-p/737517#M91866 <P>You can get the latest date using Col Max(:Date). Then you can use that create different formulas for example using date difference and a comparison</P> <PRE><CODE class=" language-jsl">Date Difference(:Date, Col Max(:Date), "day") &lt; 10</CODE></PRE> <P><A href="https://www.jmp.com/support/help/en/17.2/#page/jmp/date-and-time-functions.shtml?os=win&amp;source=application#ww2538966" target="_blank">Date and Time Functions (jmp.com)</A></P> Fri, 22 Mar 2024 05:28:15 GMT jthi 2024-03-22T05:28:15Z How to calculate date from cumulative data? https://community.jmp.com/t5/Discussions/How-to-calculate-date-from-cumulative-data/m-p/737470#M91862 <P>I have a script that is pulling data from a server everyday. It has a date column from August-present. How can I get which data is from 2 Quarters or 3 Months or 4 Weeks or 10 Days starting from the present day from the data? This calculations should be in separated columns like. And I think a flag will be needed? And is it possible to continuously calculate this using the latest added date?</P><P>&nbsp;</P><P>I'm not sure what is the easiest method for this but this is my example</P><TABLE border="1"><TBODY><TR><TD>Date</TD><TD>2 Quarter</TD><TD>3 Months</TD><TD>4 Weeks</TD><TD>10 Days</TD></TR><TR><TD>12-01-2024</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>12-02-2024</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>12-03-2024</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>12-04-2024</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>12-05-2024</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>12-06-2024</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>...</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>02-01-2024</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>0</TD></TR><TR><TD>02-02-2024</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>0</TD></TR><TR><TD>02-03-2024</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>0</TD></TR><TR><TD>....</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>03-01-2024</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>03-02-2024</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>03-03-2024</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>03-04-2024</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>03-05-2024</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>03-06-2024</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR></TBODY></TABLE> Fri, 22 Mar 2024 05:08:37 GMT https://community.jmp.com/t5/Discussions/How-to-calculate-date-from-cumulative-data/m-p/737470#M91862 UserID16644 2024-03-22T05:08:37Z Re: How to calculate date from cumulative data? https://community.jmp.com/t5/Discussions/How-to-calculate-date-from-cumulative-data/m-p/737517#M91866 <P>You can get the latest date using Col Max(:Date). Then you can use that create different formulas for example using date difference and a comparison</P> <PRE><CODE class=" language-jsl">Date Difference(:Date, Col Max(:Date), "day") &lt; 10</CODE></PRE> <P><A href="https://www.jmp.com/support/help/en/17.2/#page/jmp/date-and-time-functions.shtml?os=win&amp;source=application#ww2538966" target="_blank">Date and Time Functions (jmp.com)</A></P> Fri, 22 Mar 2024 05:28:15 GMT https://community.jmp.com/t5/Discussions/How-to-calculate-date-from-cumulative-data/m-p/737517#M91866 jthi 2024-03-22T05:28:15Z