Expand my Community achievements bar.

Submissions are now open for the 2026 Adobe Experience Maker Awards
SOLVED

Challenges with Adobe Data Warehouse date formats

Avatar

Employee

Hello Everyone, 

 

I'm exporting reports from the Adobe data warehouse and the date/time format column is coming back with what I first thought was Epoch formatting.  But that is not correct I think.  Calculators are giving the wrong year.  

 

Example: for Jan, I see dates/time stamps that look like: 

 

  • 1240001
  • 1240002
  • 1240003
  • etc.  

Just wondering what is the best way to translate that into something that is usable in a view in Snowflake using sql, etc.  Or if there is a calculated field in Tableau for the same.  Thoughts?  

1 Accepted Solution

Avatar

Correct answer by
Community Advisor and Adobe Champion

Hi @Damonwhall,

The way that format works is: 1YYMMDD, but Adobe does it a bit weird. For month, it starts counting at 0, not 1. So January is 0, February = 1.... December = 11.

 

A question similar to this was asked a while back, and has a good description in the answers. 

https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/how-to-interpret-date-ran... 

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor and Adobe Champion

Hi @Damonwhall,

The way that format works is: 1YYMMDD, but Adobe does it a bit weird. For month, it starts counting at 0, not 1. So January is 0, February = 1.... December = 11.

 

A question similar to this was asked a while back, and has a good description in the answers. 

https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/how-to-interpret-date-ran...