Date Conversion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to convert a German formatted date (19.01.2005) to 01/19/2005.
I need to do this directly in the table or even a query....I do not know
code so if anyone can help me build something in the Expression builder (i.e.
formula) it would be appreciated....Thanks!
 
Send said:
I need to convert a German formatted date (19.01.2005) to 01/19/2005.
I need to do this directly in the table or even a query....I do not know
code so if anyone can help me build something in the Expression builder (i.e.
formula) it would be appreciated....Thanks!
Click to expand...

m/d/yyyy is just a display option. Use the Format property of the
column in the table or any query you are working on.
 
I already tried that....I changed the data type to Date/Time, and tried all
of the formats for date. It does not recognize this format. When I try to
save it tells me that all of my date values will be deleted....Am I doing
something obviously wrong?
thanks -
 
I need to convert a German formatted date (19.01.2005) to 01/19/2005.
I need to do this directly in the table or even a query....I do not know
code so if anyone can help me build something in the Expression builder (i.e.
formula) it would be appreciated....Thanks!
Click to expand...

If this is a Text field, I'd suggest creating a Date/Time field in the
same table; run an Update query updating the new field to

DateSerial(Right([textdate], 4), Left([textdate], 2), Mid([textdate],
4, 2))

John W. Vinson[MVP]
 
Back
Top