Template:ReportBuilderDateFormatOption

From SmartWiki
Revision as of 15:11, 24 June 2013 by Arthur Lathrop (talk | contribs) (Created page with '==Report Builder Date Format Option== Under the Calculated Field section, you can use the following format for a date field DATE_FORMAT([this], '%W, %M %D') -- Thursday, Novem…')

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Report Builder Date Format Option

Under the Calculated Field section, you can use the following format for a date field

DATE_FORMAT([this], '%W, %M %D') -- Thursday, November 5th

DATE_FORMAT([this], '%h:%i %p') -- 11:45 AM - 02:00 PM

Syntax Output
DATE_FORMAT([this], '%W, %M %D') Thursday, November 5th
DATE_FORMAT([this], '%h:%i %p') 11:45 AM, 02:00 PM
Retrieved from ‘https://wiki.smartsimple.com/index.php?title=Template:ReportBuilderDateFormatOption&oldid=15763’