Environment

Adobe Analytics
Data Warehouse

Date Formats

When applying granularity in Data Warehouse, a Date column is added to the report. Depending on the granularity selected, the date format changes.

Granularity

Format

Example

None N/A N/A
Hourly mmmm d, yyyy Hour H January 1, 2018, Hour 0
Daily mmmm d, yyyy January 1, 2018
Weekly Week w, yyyy Week 1, 2018
Monthly mmmm yyyy January 2018
Quarterly Quarter yyyy 1st Quarter 2018
Yearly yyyy 2018

Bold words in the table above appear as they are shown.

 

Legend:

Component

Meaning

H Hour. Not prefixed by 0 if there is single digit. Range is 0 - 23
d Date. Not prefixed by 0 if there is single digit. Range is 1- 31
w Week. Not prefixed by 0 if there is single digit. Range is 1 - 52
mmmm Full month name. Ranges from January to December
q Indicate the quarters of the year. Values are 1st, 2nd, 3rd, and 4th. 
yyyy Year in 4 digits

Additional resources

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy