5 Replies Latest reply: Dec 8, 2010 7:40 AM by dvavasis RSS

    Regarding date difference

      Dear All,

      Can anyone suggest me that how can we calculate the difference between two dates and the answer comes in nos. of days:

      is there any function or something else

      i will gv u an example that what i want to do ie:.......................................

      i hv to calculate "avg payment time"

      date 1: 6/26/2008 (is billing date means invoice generate on that date)

      date 2: 7/15/2008 (is that date where payment is clear means all payment received on that date)

       

      now, we have to calculate the difference between these two dates means (date2 - date1)

      and output comes in "no of days" format. means how much days they will take to clear their bill.

       

      plz tell me the suitable solution ASAP

       

      Regards

      Neetu Singh