Covert US Dates to EU Dates

[AnthonyT]

Hi All

Have an issue with non-standardized dates in a DB - feeds come in from diff systems - for reporting purposes I need all dates to be European and due to the use of the dates in a number of Concatenated Keys conversion needs to take place in Access.

Have seen various answers based on left, mid and right but the dates in my data can be: 7/7/2009 [7th July 2009] or 10/7/2008 [7th Oct 2008] or 7/17/2009 [17th July 2009]

Any Ideas?

Thanks

 

[giovaanni]

Format(CDate(Datestring),"dd/mm/yyyy") where Datestring is the string coming in from your data.

If it is already in date time format, then just use:

Format(Date,"dd/mm/yyyy")

 

[boblarson]

I would use DateSerial in this case so that there is no confusion as to which part is which (month or day). CDate will may generate some inaccurate data in this case.