Updating script with specific dates
How would I rewrite the script to account for both [Program approved] and [Permanently Rejected] fields to be specific for dates below? June2016 - May2017=2016 June2017 ? May2018=2017 ...
Forum Discussion
I think this is what you want but I did not test it:
var Date CriticalDate = Min([Program approved], [Permanently Rejected]);
If($CriticalDate <= Date(2016,12,31), "2016",
$CriticalDate <= Date(2017,12,31), "2017",
$CriticalDate <= Date(2018,12,31), "2018",
$CriticalDate <= Date(2019,12,31), "2019"
)