Date Format

[wfairbanks]

I am importing data into my SQL db. It is pulling the date in the format of yyyy-mm-dd. I would like for it to be dd-mm-yyyy or dd/mm/yyyy. Can anyone help me with this?

Thanks in advance for your expertise!
Wendy

 

[amorous]

Make the date field in the SQL server as shortdatetime type.
Then the dates get stored in mm/dd/yyyy format.

Hope that helps.

VJ