Challenges with Adobe Data Warehouse date formats | Community
Skip to main content
Damonwhall
Adobe Employee
DamonwhallAdobe Employee
Adobe Employee
March 29, 2024
Solved

Challenges with Adobe Data Warehouse date formats

  • March 29, 2024
  • 1 reply
  • 1680 views

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?  

Best answer by MandyGeorge

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-range-minute-from-datawarehouse-export/m-p/624390 

1 reply

MandyGeorge
Community Advisor and Adobe Champion
MandyGeorgeCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
March 30, 2024

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-range-minute-from-datawarehouse-export/m-p/624390 

    Terms & ConditionsAccessibility statement

    Loading footer...