How can I setup a date field that only allows the last day of the month?

  • Profile Image
    jaspicker
    Asked on November 17, 2017 at 06:42 PM

    2) Calendar/date select tool that allows the selection of ONLY the last day of the month

  • Profile Image
    Jim_R
    Answered on November 17, 2017 at 06:54 PM

    This is doable but I don't think there's an easier way to achieve this. The DATE PICKER field allows you to limit certain date ranges but this would mean you'd have to filter out the date ranges per month.

    e.g. (YYYY-MM-DD format)

    2017-11-01>2017-11-29

    2017-12-01>2017-11-30

    The 2 lines above would mean that the DATE PICKER field will disable Nov. 1 up to Nov 29 AND Dec. 1 up to Dec. 30. You have to declare each month on its own separate line on the DISABLE DATE RANGES section of the date picker's LIMITS tab.

    The guide linked below discusses these in great detail. The section you're looking for is on section 5. Disable Date Ranges.

    Complete guide: How-to-Use-the-Date-Limits-Option