Date range hour - data warehouse report

[jane_12]

Hi,

I have pulled out a data warehouse report and added a column - Date Range Hour. How do I read the data now?

[DanIMS1 · Accepted solution]

Hi @jane_12 

The last two digits are the hours of the day.
The split is 1 | 25 (year) 06 (month-1) 29(day) 00 (hour)

Here are examples for you I have just ran to show this.:

Actual Date and Hour	Date Range Hour Value
June 1, 2025, Hour 0	125050100

Actual Date and Hour	Date Range Hour Value
June 2, 2025, Hour 17	125050217

Actual Date and Hour	Date Range Hour Value
August 3, 2025, Hour 8	125070308

Hope this helps,
Dan

[jane_12]

Thank you, @DanIMS1 this is helpful.