Functions to find 1st Saturday of month.

  • SBVA
    Asked on April 5, 2020 at 8:57 PM

    Is there an easy way to get the nth weekday of a month (e.g. 1st Saturday of the month  or 2nd Sunday of the month and so on).  Can you suggest a method?

    For the sophistication of Jotform, I think it should be able to support a lot more built-in functions for Date related and text related manipulation.

  • Ashwin JotForm Support
    Replied on April 6, 2020 at 6:08 AM

    I am not sure if I have understood your question correctly. Do you mean to say that you want to limit date in date field?

    Yes there are several options available in date field. I would suggest you to please take a look at the following guide which should help you: https://www.jotform.com/help/337-How-to-Use-the-Date-Limits-Option 

    Hope this helps.

    Do get back to us if you have any questions. 

  • SBVA
    Replied on April 6, 2020 at 10:25 AM

    I know how to use limit dates in a date field.  What I need is to populate a field with the 1st Saturday of a month. E.g. for the current month Apr 4, 2020, next month it is May 2, 2020 and so on...

    Any suggestions?

  • Ashwin JotForm Support
    Replied on April 6, 2020 at 11:45 AM

    I do not think it is possible to write such complicated function to get the 1st Saturday of month in date or form calculation widget. 

    I will check and get back to you if I am able find any function to achieve this.