Limit date range in a calendar popup

[JKSGT]

Is it possible:
1. to grey out or not display dates before today
2. before a certain date in the past
3. after a certain date in the future in the popup calendar?
If so, any pointers would be appreciated.
Many thanks

[astroboy]

Hi @JKSGT, I'm not sure if there's a workaround to do this using the standard features but I was able to find this JavaScript discussion about this customization that might be helpful for you to achieve this on your DataPages. You may check the thread here:

https://stackoverflow.com/questions/49643120/how-to-disable-previous-dates-in-calendar-javascript

Cheers!

[JKSGT]

Many thanks!

 

[Kurumi]

Hi - these new posts might help:

 

[Kurumi]

Hi! - Just wanted to share this solution. If you want to save and restrict/disable Date. You may use an external JS library called flatpickr: https://flatpickr.js.org/getting-started/ 

To apply in the DataPage, follow these steps:

1. Insert Header and Footer. In the Footer, insert the code below. Make sure to disable first the HTML Editor in the Advanced Tab.

<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/flatpickr/dist/flatpickr.min.css">

<!-- jQuery -->
  <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
 <!--  Flatpickr  -->
  <script src="https://cdn.jsdelivr.net/npm/flatpickr"></script>

<script>

$("#InsertRecordAppointment").flatpickr({
    dateFormat: "d/m/Y",
    altInput: true,
    altFormat: "m/d/Y",
    disable: [
        {
            from: "26-10-2022",
            to: "31-10-2022"
        }
    ]
});

</script>

Optional: You can insert this Style/CSS in the Header to change the font based on your DataPage's style.
 

<style>

.flatpickr-calendar {

 font-family: system-ui !important;

}

</style>

To know the formats, you can check them here: https://flatpickr.js.org/formatting/

enableTime - you are enabling time to the picker
dateFormat - format of the date that will be saved in the table. Caspio only accepts MM/DD/YYYY format in the table.
disable: range of date that you would like to disable - format will be based on the the dateFormat 

If you want to have a different display in the Text Field when selecting Date and Time, you can add altInput. altInput hides your original input and creates a new one.

Upon date selection, the original input will contain a m/d/Y H:i string, while the altInput will display the date in a more legible, customizable format.

Example:

$("#DATETIMEFIELD").flatpickr({
    enableTime: true,
    dateFormat: "m/d/Y H:i",
    altInput: true,
    altFormat: "F j, Y H:i"
});

IMPORTANT Note: Uncheck the Calendar pop-up in the field to apply the flatpickr.

Result:

[PotatoMato]

Hi! Just to add, Caspio has released a new article for disabling future dates: https://howto.caspio.com/tech-tips-and-articles/disabling-past-or-future-dates-in-calendar/

 

-Potato

[Quinn]

The solution posted above my MeeKeee is fantastic and one I have been looking for for a long time.

In addition for those that are interested, you can remove the disable date range and apply a min and max:

  minDate: "today",
  maxDate: new Date().fp_incr(3) // Set max date to today + 3 days

 

For Example:

$("#InsertRecordNextPayDate").flatpickr({
    dateFormat: "d/m/Y",
    altInput: true,
    altFormat: "d/m/Y",
    minDate: "today",
    maxDate: new Date().fp_incr(3) // Set max date to today + 3 days
});