Challenges with Adobe Data Warehouse date formats

[Damonwhall]

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?  

[MandyGeorge · Accepted solution]

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