topic Re: date difference issue in QlikView

date difference issue

Mon, 01 Dec 2014 13:49:04 GMT

i'm having issue in date difference

its not showing proper.

Please refer attached application for better understanding

Anonymous — Mon, 01 Dec 2014 13:59:23 GMT

InflowDateNew is a timestamp field, not a pure date so it needs the floor() function to make it true date.

Maybe like this in your expression for pendingdays

Interval(floor(date(Today(),'DD/MM/YYYY'))-floor(InflowDateNew))

Although I would certainly floor() it in the script.

its_anandrjs — Mon, 01 Dec 2014 14:59:34 GMT

Hi,

Try this also for getting the day difference in the days

Interval(date(Today(),'DD-MMM-YYYY') -Floor(Date(InflowDateNew,'DD-MMM-YYYY')),'d')

For Test Expression

Aggr((Num(date(Today(),'DD-MMM-YYYY') - Floor(date(InflowDateNew,'DD-MMM-YYYY')), 'DD')), InflowDateNew)

Regards

Anand