Forum Discussion
StephenAnguiano
Qrew Cadet
This is the logic I decided to use:
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")
But it is making everything "2018". I know I have about 400 records that should be "2018" currently.
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")
But it is making everything "2018". I know I have about 400 records that should be "2018" currently.
StephenAnguiano
7 years agoQrew Cadet
Program Year is determined by either [Program approved] or [Permanently Rejected]. Do you see the Dynamic Filter it has "Blank" for a year? It is because [Program approved] or [Pernanently Rejected] is "Null".
Will this script below fix that "Blank" in my Dynamic Filter?
IF(not IsNull([Program approved]), ToText(Year([Program approved])),not IsNull([Permanently Rejected]), ToText(Year([Permanently Rejected]))),
IF(
IsNull([Program approved]) and Isnull([Permanently Rejected]), "2018")
Thanks
Will this script below fix that "Blank" in my Dynamic Filter?
IF(not IsNull([Program approved]), ToText(Year([Program approved])),not IsNull([Permanently Rejected]), ToText(Year([Permanently Rejected]))),
IF(
IsNull([Program approved]) and Isnull([Permanently Rejected]), "2018")
Thanks