Today function with a Parameters Query

J

john mcmichael

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.
 
M

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
 
J

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.
Click to expand...

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

just fyi
 
Top