Difference between revisions of "Using Date Translation in Reports"

From SmartWiki
Jump to: navigation, search
Line 3: Line 3:
 
* '''Year''' – only the year number is displayed – e.g. 2004.
 
* '''Year''' – only the year number is displayed – e.g. 2004.
 
* '''Month''' – only the month is displayed – e.g. 12.
 
* '''Month''' – only the month is displayed – e.g. 12.
* '''Long Year Month''' – the long form date is displayed – e.g. 2004-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.
+
* '''Short Year-Month''' – the short form is displayed – e.g. 04-12.
* '''Short Year Month Day''' – the short form including the day is displayed – e.g. 04-12-20.
+
* '''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.
 
* '''Year Month''' - the short form is displayed – e.g. 04-12.
 
* '''Week''' – the week number from – e.g. 52.
 
* '''Week''' – the week number from – e.g. 52.
 
* '''Day''' – the day of the month – e.g. 123.
 
* '''Day''' – the day of the month – e.g. 123.
* '''Full Day Time''' – the date and the time – e.g. 2004-12-20 15:23.
+
* '''Full Daytime''' – 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.
 
1. Modify the current report to show the '''start date''' field in a '''Week''' format.

Revision as of 15:32, 10 August 2012

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 Daytime – 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.

Reps45.png

2. Modify the current report to show the start date field in a Year format.

Reps51.png


Report Builder Date Format Option

Under 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