How to calculate date from cumulative data?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 2 Quarters, 3 Months, 4 Weeks, 10 Days starting from the present day from the data?
Automation and ScriptingWindowsRe: How to calculate date from cumulative data?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
Date Difference(:Date, Col Max(:Date), "day") < 10
Date and Time Functions (jmp.com)
