Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date format

Thread starter sssu
Start date Apr 28, 2004

Status: Not open for further replies.

Apr 28, 2004

sssu

Computer

Hi,
Can anyone help?

I need to change a date from the format
'yyyy-mm-dd hh-mm-ss' to 'just dd-mm-yyyy'.
This is with the intention of eventually changing it to datenum.
Using the Datestr fucntion generates the response that 1993 is too large to be a months.

Thanks.
Much appreciated.