Time Date format conversion UDF

[timevex]

Hi,

Does anyone know of a date time format conversion UDF?

I'm looking to convert: mm/dd/yy hh:mm:ss AM/PM to yyyy-mm-dd hh:mm

Wondering if anyone has a udf out there that does basic date time stamp format conversions.

Thanks

Tim

[Affe]

Look in the helpfile.

Go to the index, type in "_date" and you will see many functions available for this.

If you can't find the exact format you want, you will have to create it using String functions.

Also, if the above format (mm/dd/yy hh:mm:ss AM/PM) is already given to you, all you need to do is reformat it using StringSplit and other various functions.

Edited October 15, 2010 by Affe