Re: Today function with a Parameters Query



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



"john mcmichael" <johnmcmichael@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C7F81058-86C6-4DD5-B6F7-9B8255A8A099@xxxxxxxxxxxxxxxx
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.


.