7 Replies Latest reply on Apr 27, 2018 5:28 AM by Zhouyi Zhang

    Timedifference from difference datatyp

    Lea Zimmer

      Hi together,


      i have a question to the area Timedifference, i wish to see the difference in hours, but ich have difference date forms see the Picture in the attach.


      My target is that i have example the result 8 Hours "Due Date-due_time" but actuel my result ist with the formel Datediff('hour',[Due Date],[due_time]) is -1.035.808 etc. but it shout be the value 8


      Thanks for your help