3 Replies Latest reply: Jul 19, 2013 10:08 AM by Philippe Grenier RSS

    Dates appear from nowhere !!!

    Phil Speight

      Hi

       

      I am a newbie here, so please excuse me.

       

      I have 2 date fields that I have created an expression that has an if statement as below

       

       

      =

      If(

      [1HR Start Date]-[1HR Offer Date]

      =0 ,

      '0 Days',


      )

       

       

      However for some reason when I filter on this I get additional dates and I cannot understand why.  I have exported to excel to check the formular in excel and it worksWhat am I doing wrong?

       

      Thanks in advance

       

       

      Phil