Today function with a Parameters Query

[Guest]

Can Use the the Today function with a Perameters Query. Something like...

between [ Enter Start Date ] and Today ?

Thanks for the input and have a great day.

 

[Michel Walsh]

BETWEEN [Enter Start Date] AND Today() + #23:59:59#



I added #23:59:59# to include the whole day, ie, to NOT stop the limit at
today morning, at midnight, but up to today, as in 'almost tomorrow. That is
not required if you don't have TIME values, in addition to dates, but if you
have times, you have to add these 24hours.


Hoping it may help,
Vanderghast, Access MVP

 

[juangregory]

Can Use the the Today function with a Perameters Query. Something like...

between [ Enter Start Date ] and Today ?

Thanks for the input and have a great day.

I think that
between (([enter start date]) and date())
should work too

just fyi