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.
Retrieving data ...