Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

date difference issue

i'm having issue in date difference

its not showing proper.

Please refer attached application for better understanding

2 Replies

Re: date difference issue

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.

Re: date difference issue

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

Community Browser