Formatting Dates and Times in the Microsoft FrontPage® Database Results Wizard

Dates and times in your database can be reformatted using the Custom Query option in the Database Results Wizard - here are some examples:

SELECT format(YourDate,'mm/dd/yyyy') gives you: 01/02/2004

SELECT format(YourDate,'mmm dd, yyyy') gives you: Jan 02, 2004

SELECT format(YourDate,'mmmm dd, yyyy') gives you: January 02, 2004

SELECT format(YourDate,'mmmm d, yyyy') gives you: January 2, 2004

SELECT format(YourDate,'ddd mmmm d, yyyy') gives you: Fri January 2, 2004

SELECT format(YourDate,'dddd mmmm d, yyyy') gives you: Friday January 2, 2004

Resources (scroll down to the Remarks section):

ms:format-date Function http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/html/51f35609-89a9-4098-a166-88bf01300bf5.asp

ms:format-time Function http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/html/51f35609-89a9-4098-a166-88bf01300bf5.asp