zubin6220
asked on
Function to check if current date is equal to any date between two dates.
I'm looking for the function that will pull the records for personnel that are on vacation during the date the report is run. Using fields: StartVacDate and EndVacDate.
Your help is greatly appreciated
Your help is greatly appreciated
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much.
in your report add a textbox
put this as controlsource:
=IIf(([startvacdate]<=Now(