Changes

Using Date Translation in Reports

34 bytes added, 14:07, 25 September 2013

no edit summary

{{SeqReportPageHeader}}

 

You can change the format of the dates to any of the following '''Date/Time Translation''' settings:

* '''Year''' – only the year number is displayed – e.g. 2004.

* '''Month''' – only the month is displayed – e.g. 12.

* '''Long Year -Month''' – the long form date is displayed – e.g. 2004-12.* '''Short Year -Month''' – the short form is displayed – e.g. 04-12.* '''Year-Month-Day''' - the standard form is displayed - e.g. 2004-12-20.* '''Short Year -Month -Day''' – the short form including the day is displayed – e.g. 04-12-20.

* '''Year Month''' - the short form is displayed – e.g. 04-12.

* '''Week''' – the week number from – e.g. 52.

* '''Day''' – the day of the month – e.g. 123.

* '''Full Day TimeDaytime''' – the date and the time – e.g. 2004-12-20 15:23.

1. Modify the current report to show the '''start date''' field in a '''Week''' format.

=Report Builder Date Format Option=Under Calculated Field section, you can use the following format for a date field{{ReportBuilderDateFormatOption}}

DATE_FORMAT({{PrevNextStart}} [this[Using Date Criteria]]{{PrevNextMid}} [[Using a Date Range in a Report]], '%W, %M %D') -- Thursday, November 5th {{PrevNextEnd}}

DATE_FORMAT([this[Category:Date Formats]], '%h:%i %p') -- 11:45 AM - 02:00 PM

• ← Older edit

Arthur Lathrop

8,849

edits