How to find the dates are in between holidays date
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-13-2024 01:57 PM
We have holiday schedules and trying to book the appointment from Catalog item. I would like to display message if user is selecting start or end date between or on the holiday dates.
When i try to get the date values and I'm getting it in below format
13-Aug-2024 04:15 PM
Below is the script i tried but not going inside IF statement

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-13-2024 02:03 PM
If the holiday schedules are known, you could use one of the below date validations without coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-13-2024 03:37 PM
We have a holiday schedules in different table and I have to validate those dates with current variables .
Above article is using OOB filters like today or between.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-13-2024 03:43 PM
Never compare display values of date/time fields. There are lots of possible formats and you never know what the result of ">" and "<" comparisons is going to be because they are compared as strings. Moreover, different users can have different date/time format settings.
Instead, you should always compare numeric representations of date/time field values.
Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/