Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i'm having issue in date difference
its not showing proper.
Please refer attached application for better understanding
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.
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