Template:ReportBuilderDateFormatOption
Revision as of 14: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…')
Revision as of 14: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…')
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 |