3 Replies Latest reply: Oct 13, 2016 2:55 PM by Sunny Talwar RSS

    calculate how many weeks from today to a given date

    Josh Chang

      Hello

       

      I would to know how to calculate how many weeks from today to a given date.

      For example as attached,

      I used

      floor(Interval(Today()-CalendarYMD,'D')/7)

      to calculate how many weeks from today to a given date.

      But, you can see here, there are different values for days in the same week.

      week_cal.PNG