How to check if current date is between two dates

[Adzi]

Hi,

I have an arrival date and a departure date and I need to work out if the current date is within the two dates. It's a criteria for one of my fields on the query I'm using as the backbone for a list box. Any help greatly appreciated

Thanks,
Adzi

 

[rainman89]

date() BETWEEN startdate AND enddate

 

[Adzi]

Thanks very much