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

 

[Guest]

You can use Format() to return the date in the format you wish. It works in
queries and VBA.

Daniel

 

[savigliano]

thank you very much i will try it
carlos

 

[John Vinson]

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

The Format is *NOT* the problem. The Format merely controls how the
value stored in the table is displayed.

An Access Date/Time value is stored as a number - a count of days and
fractions of a day (times) since midnight, December 30, 1899.

If you wish to permanently remove the time portion (destroying data
that you might realize later that you need!) you can run an Update
query updating the field MyDateField to

DateValue([MyDateField])

Or you can solve the problems in your queries - if you could describe
the nature of the problems we can try to solve them for you.

Su Ingles es mucho mejor que mi Español! <g>

John W. Vinson[MVP]