Date range hour - data warehouse report | Community
Skip to main content
J
jane_12
Level 3
August 4, 2025
Solved

Date range hour - data warehouse report

  • August 4, 2025
  • 1 reply
  • 273 views

Hi,

 

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

 

    Best answer by DanIMS1

    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 0125050100

     

    Actual Date and Hour Date Range Hour Value
    June 2, 2025, Hour 17125050217

     

    Actual Date and Hour Date Range Hour Value
    August 3, 2025, Hour 8125070308

     

    Hope this helps,
    Dan

    1 reply

    DanIMS1
    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 0125050100

     

    Actual Date and Hour Date Range Hour Value
    June 2, 2025, Hour 17125050217

     

    Actual Date and Hour Date Range Hour Value
    August 3, 2025, Hour 8125070308

     

    Hope this helps,
    Dan

      J
      jane_12Author
      Level 3
      August 4, 2025

      Thank you, @danims1 this is helpful.

      Terms & ConditionsAccessibility statement

      Loading footer...