Template:ReportBuilderDateFormatOption

Revision as of 10:16, 11 November 2013 by Arthur Lathrop (talk | contribs) (Report Builder Date Format Option)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Revision as of 10:16, 11 November 2013 by Arthur Lathrop (talk | contribs) (Report Builder Date Format Option)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Report Builder Date Format Option

Under the Calculated Field section of the Report Builder, you can use the following format for a date field:

Syntax Output
DATE_FORMAT([this], '%W, %M %D') Thursday, November 5th
DATE_FORMAT([this], '%h:%i %p') 11:45 AM, 02:00 PM