Solved
Date range hour - data warehouse report
Hi,
I have pulled out a data warehouse report and added a column - Date Range Hour. How do I read the data now?
DanIMS1Accepted solution
Level 3
August 4, 2025
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