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
My requirements have changed and know not dependent on Customer.
So will the following still work if I write :
If(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")
Just curious if [Program approved] is blank/null does the formula think it is greater than 12.31.2017?
Thanks.
So will the following still work if I write :
If(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")
Just curious if [Program approved] is blank/null does the formula think it is greater than 12.31.2017?
Thanks.