FormatDateTime formats FileMaker Pro date and time data using PHP Date formatting syntax. Returns a string of 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. This custom function formats the output using PHP Date function format codes but with FileMaker conventions.<\/p>\n
Passing ‘?’ as the only text in format returns this help text with the following code explanations.<\/em><\/strong><\/p>\n<\/p>\n Escaped \\ is written \\\\, all other escaped text must be enclosed within an opening \\ and a closing \\.<\/p>\n Formatting performed using PHP Date function format syntax but with FileMaker Pro conventions.<\/p>\n Day ——-<\/strong><\/p>\n Week —–<\/strong><\/p>\n Month —-<\/strong><\/p>\n Year —–<\/strong><\/p>\n Time —-<\/strong><\/p>\n NOTICE:<\/strong> This function is a recursive function. If you change the name of it, then change the name references inside the code.<\/p>\n FormatDateTime code:<\/strong> Copy the selected code below (click on Select All to highlight all the code) to the clipboard and paste it into a newly created Custom Function. Download the code in a text file from here.<\/a><\/p>\n\n
\n
\n
\n
\n