0 Replies Latest reply on Jul 30, 2013 9:39 AM by Ben Shirley

    DateDiff between 3 or more dates..

    Ben Shirley

      Hi,

       

      I am looking to show the "Datediff" between a few dates to build a GANTT chart, however there are few columns in my data that will have NULL values.

       

      For Example, Date Order Received "DateDiff" Date part Requested, if i already have the part then show Date order received DateDiff Date posted out.

       

      I have:
         
                 DATEDIFF('Day',[Date Order Received],[Date Part Requested])             -  Which works just fine.

       

      Now i need the IF [Date Part Requested] is NULL then show DATEDIFF('Day',[Date Order Received],[Date Posted Out])

       

      ????

      Any help is greatly appreciated.

       

      Ben