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.