converting general date format data into short date format

[savigliano]

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

[tina]

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

[savigliano]

thank you very much i will try it
carlos