Remove time from a date field
Aug 26 2005, 10:35 AM
Joined: 26-August 05
I have a table with a date field that has date and time in it, example: 8/26/2005 7:45:39 AM
Oneed to be able to strip the time out, and just use the date, so that I can then create a relation from that field to another table with a date field that has just the date in it. Can anyone help me? thanks guys...
Aug 26 2005, 10:54 AM
Joined: 23-September 04
From: NC, USA
welcome to UA forums.
Use the datevalue function to pull the date out of your field. Make a query and in a new column in that query you can use:
FOr you could use an update query to update the original field with similar syntax if you don't NEED the time anymore!
Aug 26 2005, 11:06 AM
Joined: 4-August 05
From: Stowe, Vermont
I don't know if this would help but i believe you can just go to the design view of the table and just change the format of the date field to reflect just the date. For example change the format from "general Date" to "Short date" this will take off the time.
|Search Top Lo-Fi||1st February 2015 - 03:40 AM|