date difference issue

[#1]

i'm having issue in date difference

its not showing proper.

Please refer attached application for better understanding

[Anonymous]

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]

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