4 Replies Latest reply on Apr 26, 2018 8:29 AM by Shinichiro Murakami

    Complex Calculation with difference data type

    Lea Zimmer

      Hello thogether,

       

      I have a Problem with a Calculation

       

      The case is example:

       

      01.03.2018 19:50:00 + (-1) - (01.03.2018 00:00:00 +09:30:00)

       

      Data Typ + Attribute type - (Date type + Date type)

       

      The result shout be: 18:50 - 09:30 o'clock is 09:20 hours

       

      The second problem is in the field with the 08:00:00 hour hear is only the time and no date.

       

      Is this calculation possible?

       

      Thanks