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

    DateDiff between 3 or more dates..

    Ben Shirley



      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.