S
Seth
Access 2003
Windows XP
I have a form for entering data from the previous day. It includes a
field that allows the entry clerk to enter the number of days offset
from the current day. The default is 1 but any number can be entered
so if the entry is being made on Monday, the number entered for the
offset will be 3. On the form there is a date field for the date, it
defaults to today's date minus the number of days offset ( =now()-
[txtDaysOffset] ).
My problem is the date field on the table is populated with the date
entered plus the current time. I know it's because of the Now
function. This makes it almost impossible to write queries to find
records by date.
Is there a way to use the Now function with only the date and not the
time. Excel has the Today, is there something comparable in Access?
Windows XP
I have a form for entering data from the previous day. It includes a
field that allows the entry clerk to enter the number of days offset
from the current day. The default is 1 but any number can be entered
so if the entry is being made on Monday, the number entered for the
offset will be 3. On the form there is a date field for the date, it
defaults to today's date minus the number of days offset ( =now()-
[txtDaysOffset] ).
My problem is the date field on the table is populated with the date
entered plus the current time. I know it's because of the Now
function. This makes it almost impossible to write queries to find
records by date.
Is there a way to use the Now function with only the date and not the
time. Excel has the Today, is there something comparable in Access?