Interval function with date field not working

[ashmitp869]

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

[MayilVahanan · Accepted solution]

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