Skip to main content
Damonwhall
Adobe Employee
DamonwhallAdobe Employee
Adobe Employee
Mar 29, 2024 5:00 PM UTC
Solved

Challenges with Adobe Data Warehouse date formats

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?  

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
MandyGeorge
MandyGeorgeAccepted solution
Adobe Champion, Community Advisor, UG Leader
Mar 30, 2024 1:00 AM UTC

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 

View in thread

1 reply

MandyGeorge
Adobe Champion, Community Advisor, UG Leader
MandyGeorgeAdobe Champion, Community Advisor, UG LeaderAccepted solution
Adobe Champion, Community Advisor, UG Leader
Mar 30, 2024 1:00 AM UTC

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 

Translate
    Terms & ConditionsAccessibility statement

    Loading footer...