The formatDate example for a custom function

You can learn about creating a custom function by using an example. The example shows how to build a function, called formatDate, that parses a string-based date representation and returns it in an alternative format.

The function syntax is as follows:

formatDate( date, inputFormat [, outputFormat] )

Note the following examples of the function:

formatDate( "05102004", "ddMMyyyy" ) returns the date in the format "2004-10-05".

formatDate( "05/10/04 13:25", "dd/MM/yy HH:mm", "dd MMM, yyyy hh:mm:ss a" ) returns the date in the format "05 Oct, 2004 01:25:00 PM".