FormatDateTime ( dateValue, timeValue, format ):
Format the dateValue and/or timeValue as specified in format. If dateValue or timeValue are empty current date or current time are used. Optionally, use the backslash as an escape code to include text not intended to be formatted. Formatting performed using PHP date() function format codes but with FileMaker conventions.
Examples:
FormatDateTime ( 10-31-2011, “”, “D., F j, Y”) = Mon., October 31, 2011
FormatDateTime ( 10-31-2011, 11:06:53, “Y-m-d His \zulu\”) = 2011-10-31 084621 zulu
FormatDateTime ( 10-31-2011, “”, “\today is the \dS\ day\”) = today is the 31st day