topic Re: Interval function with date field not working in QlikView

Interval function with date field not working

ashmitp869 — Thu, 03 Jun 2021 03:59:09 GMT

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 — Thu, 03 Jun 2021 04:42:35 GMT

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