Idea Summary Having highlighted holiday on the date picker would help user know what date to pick in the event of setting the schedule. Allow the developer to populate holiday date from the table.
This is tricky and requires holidays from around the world to be tracked and stored. I've always used my own holidays table in my apps.
Hi Jayson,
That's the idea to use our own holiday table. However, APEX does not provide a place to populate those holiday dates. In order to get it to work, I had to use the JQuery solution found on the web. The problem though, the min and max date in the datepicker setting was ignored. And sometime, it created javascript error.
Hi there,
With APEX 22.2 and the new date picker that's easily solved. The new date picker has a dayFormatter API like the jQuery date picker or the JET date picker, but you don't have to handle with JavaScript. We published a plug-in where you can use a SQL-Statement or ICS-Files. If you want to know more about it, please checkout the Sample Calendar App, this includes samples with the plug-in: https://oracle.github.io/apex
The plug-in can also be found there.
Kind regards
Ronny