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

    Dates appear from nowhere !!!

    Phil Speight



      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





      [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