6 Replies Latest reply: Sep 18, 2016 5:34 PM by Marco Wedel RSS

    Inconsistent Bi-weekly dates

    Swetha More

      Hi,

       

      I am trying to calculate Bi-weekly dates, i referred to this discussion Creating Bi Weekly in Master Calendar and used the same calculation i.e dual(text(weekstart(create_date)),div(weekstart(create_date),14)) as "BiWeekdate".

       

      This is giving me inconsistent dates like shown below. Since the interval is 14 days, for example after 27/12/2015 the next bi-weekly date should be 10/01/2016 but instead it shows 17/01/2016.

       

      What could be the reason? Anything missing here? Any help is appreciated.

      inconsitent_biweekly_dates.png

      Thanks

      Swetha