X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Remove time from a date field    
post Aug 26 2005, 10:35 AM

Posts: 1
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...
Go to the top of the page
post Aug 26 2005, 10:54 AM

UtterAccess VIP
Posts: 31,413
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:
ustDate: DateValue([YourField])
FOr you could use an update query to update the original field with similar syntax if you don't NEED the time anymore!
Good luck
Go to the top of the page
post Aug 26 2005, 11:06 AM

Posts: 218
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.
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    20th April 2018 - 12:05 AM