Link to home
Start Free TrialLog in
Avatar of zubin6220
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
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Limbeck
Limbeck

hi,

in your report add a textbox

put this as controlsource:

=IIf(([startvacdate]<=Now()) And ([endvacdate]>=Now());"on vacation";"-")
Avatar of zubin6220

ASKER

Thank you very much.