7 Replies Latest reply on Apr 18, 2017 7:04 AM by seeta t

    How to identify 3rd Saturday within a month?

    kamal kumar

      Hi All,

       

      Is there any way to extract 3rd Saturday of each month from Date field by using a calculated field?

       

      For example: Feb 3rd Saturday is 18th in 2017, but in 2018 Feb 3rd Saturday is 24th.

       

      I want to create Fiscal months starting from 1 to 12 where First month should display the date starting from 18th Feb 2017 to 25th March 2017 which is 4th Saturday of March.

      For Year 2018,  date starting from Feb 24th(3rd Saturday) to March 31st which is 4th Saturday of March.

       

      Please suggest.

       

      Thanks.