Hi,
Can anyone please tell me what this logic is doing?
Renewed: iif ([Ren Date] between [Ren_due]-7 And [Ren_Due]+15, 'Yes','No')
Hi,
Can anyone please tell me what this logic is doing?
Renewed: iif ([Ren Date] between [Ren_due]-7 And [Ren_Due]+15, 'Yes','No')
It is checking to see if the "Ren Date" falls within the following window:
7 days before the "Ren Due" date and 15 days after the "Ren Due" date.
If it falls within that window of time, it is returning "Yes", otherwise, it is returning "No".
Thank you for you're explanation
You are welcome.