How to let DateTimePicker only enable dates that exist in db?
How to let DateTimePicker only enable dates that exist in db?
panzram
Posts: 29Questions: 11Answers: 0
in DataTables
Hi,
I've been looking around and I couldn't find anything about this. Is there a way to only allow a user to select dates that are in the database, only enable dates that exist? ...or at least show a popup warning, or mark the non-existing dates in a different colour, or something similar, and that isn't too complicated and/or heavy on memory usage?
Thx.
This question has accepted answers - jump to:
This discussion has been closed.
Answers
Set up an ajax call that is triggered by a change event that goes back to the server and checks the date?
What date picker library are you using? Does it have the ability to selectively enable specific dates only?
Allan
Thanks for your replies!
bindrid:
I guess you mean that I need to check the date on the "after update" event and display a message if it's not valid. I am sort of thinking along those lines myself.
Allan:
I am using the standard one from the editor, didn't even know there was another. I've seen the disable date option in the example, but I'm not sure how I can apply that. I thought it was only a dayofweek exclusion to avoid weekends. I actually have several years of business dates, inc bank holidays, so the list would be rather long.
I see what you mean - sorry - I had thought you were talking about filtering a DataTable, not limiting the options in Editor's date picker.
Unfortunately that isn't something that is currently possible in the
datetime
field. You can disallow selection for certain days of the week, or use a max / min date, but there isn't the option to arbitrarily disable days in the calendar.The best I can think of (other than modifying the code of course) is to add a validator similar to what bindrid suggests.
Allan
Thank you both for your time! I will look into bindrid's suggestion.