2 Replies Latest reply: Dec 1, 2014 10:03 AM by Anand Chouhan RSS

    date difference issue

    snehal mejari

      i'm having issue in date difference

       

      its not showing proper.

       

      Please refer attached application for better understanding

        • Re: date difference issue
          Bill Markham

          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
            Anand Chouhan

            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