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
That looks like it will work, but I don't think that the condition will be true if the dates are null. Hence it will probably calculate to 2017.
I suggest that you specifically test for null dates and decide what you want to output for that situations.
IF(
IsNull([Program approved]) and Isnull([Permanently Rejected]), "say something",
Date(2017,12,31)>=[Program approved] or Date(2017,12,31)>=[Permanently Rejected],"2018",
Date(2016,12,31)>=[Program approved] or Date(2016,12,31)>=[Permanently Rejected],"2016","2017")
I suggest that you specifically test for null dates and decide what you want to output for that situations.
IF(
IsNull([Program approved]) and Isnull([Permanently Rejected]), "say something",
Date(2017,12,31)>=[Program approved] or Date(2017,12,31)>=[Permanently Rejected],"2018",
Date(2016,12,31)>=[Program approved] or Date(2016,12,31)>=[Permanently Rejected],"2016","2017")