Query to change YYYYMMDD to MMDDYYYY

[Tlane1969]

What would the syntax be?
I want to query field 1 text with 20070101; convert it and have a date format of 01/01/2007 in the results.

Thanks

 

[SydneyGeek]

try...
=DateSerial(Left([Field1],4),Mid([Field1],5,2),Right([Field1],2)

Denis

 

[Tlane1969]

Thank you, SydneyGeek!~

I appreciate it. Works perfectly.

 

[psamu]

try...
=DateSerial(Left([Field1],4),Mid([Field1],5,2),Right([Field1],2)

Denis

Where do I place this formula? Is it in the Criteria Field or create a new field in the query?

 

[james_lankford]

new field in a query

 

[psamu]

Thanks. It works

 

[psamu]

Could you please help me to create a field in Access Query for the serial number for each row.

Thanks.