Difference between revisions of "Template:ReportBuilderDateFormatOption"
From SmartWiki
(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) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
==Report Builder Date Format Option== | ==Report Builder Date Format Option== | ||
| − | Under the Calculated Field section, you can use the following format for a date field | + | Under the [[Calculated Field]] section of the Report Builder, you can use the following format for a date field: |
| − | |||
| − | |||
| − | |||
| − | |||
{| border="1" | {| border="1" | ||
Latest revision as of 10:16, 11 November 2013
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 |
