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

    Difference between dates

      Hi,

      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