How to set available dates in datepicker

To do this, use the date field type and set it in the procedure dict in SELECT 1 available and unavailable values (in the parameter Value).

select '' Text,'2020-09-12' Value, 0 Selected    --- comma separated AvailableDates
select '' Text,'2020-09-15,2020-09-17' Value, 0 Selected  --- comma separated DisabledDates

1 line - these are available dates (if an empty line in Value is ignored).  If set, only dates from the list will be available. 

2 line - these are unavailable dates (if an empty string in Value is ignored). If set, all dates except the specified ones will be available.

Date format YYYY-MM-DD


As a result, the markup will look like this:

<div class="asDatepicker" data-availabledates="2020-09-12" data-disableddates="2020-09-17,2020-09-15"></div>

 When displaying each day, these lists will be checked to determine whether the date is available. 

Falcon Space is a functional web development platform on a narrow stack MS SQL/Bootstrap. Falcon Space Gettting started

SQL-tool for creating personal accounts on the site

The essence of the approach and the history of the creation of Falcon Space
Web platform for creating personal accounts

Falcon Space Platform

This is a reduction in the cost of ownership

at the expense of fewer people to support

This is a quick change

while using the program

This is a modern interface

full adaptation for mobile devices

MS SQL web applications. Affiliate program for developers and web studios

You can develop on your own or collaborate with us on Falcon Space web development using only SQL and HTML.
See examples with SQL code
Platform documentation
Working on MS SQL Server