English <==> American Date conversion

[tb1150]

Hi all,



One of my data sources is American and therefore provides dates in a mm/dd/yyyy format, which is a problem as in the UK the date is stored as dd/mm/yyyy. Is there any way I can quickly change the format? Right now the only way I can think of doing this en masse is to use the excel "text to column" feature but I am looking for something cleaner. The data is being provided to me in text form.

Much appreciated.

[tb1150]

Solved: This was not too hard to solve, I simply changed the month and day values around using string functions;

ITEDate: Mid([tbl_AuditImport]![Audit date],4,2) & "/" & Mid([tbl_AuditImport]![Audit date],1,2) & "/" & Right([tbl_AuditImport]![Audit date],4)