3 Replies Latest reply: Oct 25, 2011 4:02 PM by Erich Shiino RSS

    Difference between dates


      I got 2 date fields:

      - "Dt End"

      - "Dt Start"


      Which are in the xls format:

      Dt End 40820,50326

      Dt Start 40820,01286


      I need to create a new filed which reports the difference between this dates in terms of numbers of days.


      I used this: Interval ("Dt End"-"Dt Start",'DD') as "Giorni"


      But is not working properly..it gave me results formatted in days but is seems is having decimals (not expressed) so i got lots 00,01,02,03,04 but i need them as unique values