Time Still Showing up in Date Field
Time Still Showing up in Date Field
(OP)
I have a few date fields that i formated in the table with short date and a input mask...
how come when i run a query the time still shows up??
i tryed putting the Like * & [enter Date] & * and it still wont pull up any dates?...
for some reason all my queries are like that...
is there a way around this?
I dont care if the time is still there..I just need to be able to pull these queries up by date..
can I create an update query that will get rid of the time???
Thanks
how come when i run a query the time still shows up??
i tryed putting the Like * & [enter Date] & * and it still wont pull up any dates?...
for some reason all my queries are like that...
is there a way around this?
I dont care if the time is still there..I just need to be able to pull these queries up by date..
can I create an update query that will get rid of the time???
Thanks
DVannoy
A+,Network+,CNA
dvannoy@onyxes.com
RE: Time Still Showing up in Date Field
Use # to idntify the parameter as a date?
= "#" & [Enter Date] & "#"
Terry L. Broadbent
FAQ183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.
RE: Time Still Showing up in Date Field
DateOnly: DateValue([MyDateTimeField])
If you want to update all your values and strip the time you can use the DateValue function as well. In the Update To place this:
DateValue([MyDateTimeField])
HTH
Joe Miller
joe.miller@flotech.net
RE: Time Still Showing up in Date Field
Thats the only thing i can think of
again thanks
DVannoy
A+,Network+,CNA
dvannoy@onyxes.com
RE: Time Still Showing up in Date Field
Joe Miller
joe.miller@flotech.net
RE: Time Still Showing up in Date Field
DVannoy
A+,Network+,CNA
dvannoy@onyxes.com