Jump to content
Sign in to follow this  

Time Date format conversion UDF

Recommended Posts


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.



Share this post

Link to post
Share on other sites

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 by Affe


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...