Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Time Still Showing up in Date Field 2

Status
Not open for further replies.
dvannoy

dvannoy

MIS
May 4, 2001
2,765
US
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
 
Sort by date Sort by votes

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.
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
That's exactly what happens when you use now! ;-) Joe Miller
joe.miller@flotech.net
 
Upvote 0 Downvote
= "#" & [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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Field size limit Access 365
Replies
5
Views
4K
TrekBiker
TrekBiker
monkeysee
  • Locked
  • Question
Field to count specific records
Replies
3
Views
652
dhookom
dhookom
Lidias13
  • Locked
  • Question
Odata contains fields from multiple tables in single table with different field names - for same
Replies
1
Views
543
dhookom
dhookom
MrStohler
  • Locked
  • Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship? 1
Replies
5
Views
710
SkipVought
S
HebieBug
  • Locked
  • Question
Lookup field in a table will not allow me to use auto expand 1
Replies
2
Views
392
HebieBug
HebieBug

Part and Inventory Search

Sponsor

Back
Top