1 Reply Latest reply: Feb 28, 2018 12:16 PM by Sunny Talwar RSS

    Equivalent of DayStart for Hours?

    Romain VINCENT

      I'm trying to reproduce the result of DayStart() in the backend but at the hour level. My input data consists in 'DD/MM/YYYY hh:mm:ss' timestamps.

       

      I tried this :

       

      Timestamp(Floor(($(vTransactionDateTime) * 24) / 24))

       

      but it returns rounded up data to the day level.

       

      Any idea?