G
Guest
Can anyone tell me what this expression is doing? What I'm trying to
determine is if this is counting back 365 days from today's date or the
[Screen Date].
IIf(IsNull([DEN1 Screen Date]),0,IIf(DateDiff("d",[DEN1 Screen
Date],Date())<=365,1,IIf(IsNull([DEN2 Screen Date]),0,IIf(DateDiff("d",[DEN2
Screen Date],Date())<=365,1,0))))
Thank you in advance for any help.
determine is if this is counting back 365 days from today's date or the
[Screen Date].
IIf(IsNull([DEN1 Screen Date]),0,IIf(DateDiff("d",[DEN1 Screen
Date],Date())<=365,1,IIf(IsNull([DEN2 Screen Date]),0,IIf(DateDiff("d",[DEN2
Screen Date],Date())<=365,1,0))))
Thank you in advance for any help.