469,647 Members | 1,730 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,647 developers. It's quick & easy.

converting general date format data into short date format

hello, i am doing a date comparation and i have reallize that the data
i have in my database (general date format) it is causing me problems,
and because i don´t need the time data i would like to convert all the

general date data into short date format, so i would like to delete the

time part of the data, it is any way i can do that ????
Thank you in advance and sorry for my english
carlos

converting general date format data into short date format

Nov 27 '06 #1
2 6755
to delete the "time" portion of a date/time value, you can use an Update
query, as

UPDATE TableName SET TableName.DateTimeField =
DateValue([TableName].[DateTimeField]);

replace TableName and DateTimeField with the correct names of the table and
date/time field in the table, of course. i strongly recommend that you back
up your database before running the Update query; it pays to be safe with
your data.

to ensure that all *new* values entered in the field do not include a
specific time, make sure you use the Date() function rather than the Now()
function anywhere that you set the value of the field in any record.

hth
"savigliano" <sa********@gmail.comwrote in message
news:11**********************@l12g2000cwl.googlegr oups.com...
hello, i am doing a date comparation and i have reallize that the data
i have in my database (general date format) it is causing me problems,
and because i don´t need the time data i would like to convert all the

general date data into short date format, so i would like to delete the

time part of the data, it is any way i can do that ????
Thank you in advance and sorry for my english
carlos

converting general date format data into short date format
Nov 27 '06 #2
thank you very much i will try it
carlos

Nov 27 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Gary Smith | last post: by
6 posts views Thread by yoshitha | last post: by
20 posts views Thread by andreas | last post: by
3 posts views Thread by andrew | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.