By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,299 Members | 1,175 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,299 IT Pros & Developers. It's quick & easy.

converting general date format data into short date format

P: n/a
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
Share this Question
Share on Google+
2 Replies

P: n/a
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

P: n/a
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.