Template:ReportBuilderDateFormatOption

From SmartWiki
Jump to: navigation, search

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