Time Still Showing up in Date Field 2

[dvannoy]

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

DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[tlbroadbent]

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.

 

[JoeMiller]

Extract the date value of the field by using the DateValue() function in a new column of your query, place the criteria in that new column

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

 

[dvannoy]

Thanks to both of you...I guess this happens when you use date = now()..

Thats the only thing i can think of

again thanks DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[JoeMiller]

That's exactly what happens when you use now! ;-) Joe Miller
joe.miller@flotech.net

 

[dvannoy]

= "#" & [Enter Date] & "#" when i use that command it gives me an error saying the expression is to complex or something like that..

DVannoy
A+,Network+,CNA
dvannoy@onyxes.com