4 Replies Latest reply: May 17, 2018 3:22 AM by Vishal Arote RSS

    No. Days Difference

    micro win

      Hello,

       

      I need to get the number of days between today and different dates.

       

      I use the following expression:

       

      =INTERVAL(DATE(TODAY())-DATE_TIME_TRANSACTION,'DD')

       

      (The field DATE_TIME_TRANSACTION has this format: DD/MM/YYYY hh:mm:ss)

       

      The problem is that when I have transactions from today, it returns me the value -1.

       

      Do you know how could I solve this?

       

      Thank you!