8,849
edits
Changes
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
{| border="1"
|'''Syntax'''
|'''Output'''
|-
|DATE_FORMAT([this], '%W, %M %D')
|Thursday, November 5th
|-
|DATE_FORMAT([this], '%h:%i %p')
|11:45 AM, 02:00 PM
|}
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
{| border="1"
|'''Syntax'''
|'''Output'''
|-
|DATE_FORMAT([this], '%W, %M %D')
|Thursday, November 5th
|-
|DATE_FORMAT([this], '%h:%i %p')
|11:45 AM, 02:00 PM
|}