Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I want the phase length (days) from the below table. I am using this in script -
IF(LEN([Phase_End_Date]) > 1,Interval( (date#((Phase_End_Date),'DD/MMM/YYYY')) - (date#(Phase_Start_Date,'DD/MMM/YYYY')), 'D'),0) as Phase_length
But getting NULL values. Please suggest
Hi @ashmitp869
Based on ur screenshot, both Phase_End_Date & Phase_Start_Date are in date format already. So try like below
IF(LEN([Phase_End_Date]) > 1,Interval( Floor(Phase_End_Date) - Floor(Phase_Start_Date), 'D'),0) as Phase_length
Hi @ashmitp869
Based on ur screenshot, both Phase_End_Date & Phase_Start_Date are in date format already. So try like below
IF(LEN([Phase_End_Date]) > 1,Interval( Floor(Phase_End_Date) - Floor(Phase_Start_Date), 'D'),0) as Phase_length