Formatting dates to strings with Formatdate()

You can use the Formatdate() function to convert a date to a string. Use the following syntax:

formatdate(<date>, <format_string>)

For example, to extract the month number from a date, use the following syntax:

formatdate(<date>,”MM”)

If you process a date in November through the above example, it returns an “11” to indicate November.