convert data for display

[ehnruiz]

How can I use sql to convert the following text field data 5/14/2009 to display as 2009-05-14. I am using a text field.

Thanks

 

[MSAccessRookie]

How can I use sql to convert the following text field data 5/14/2009 to display as 2009-05-14. I am using a text field.

Thanks

You can try using the Format() command to reformat the string as a date.

FORMAT(YourTextDate, "yyyy-mm-dd")
​

 

[ehnruiz]

Txs, that's exactly what I ended up using. Appreciate pointing me in right direction.