the query for the start and end date
I was only saying that IF BOTH are weekly or fortnightly, then you can go by day of the week to find a clash. Of course there can also be a clash daily which should be the first check. Naturally monthly can also clash, but it's more difficult to do because the day of the month varies on the same date of each month! So you'd need to think carefully about that. Incidentally, you may find that "day of month" isn't an ideal booking method because, unless you book 7 days a week, it could easily end up being a Sunday... and who wants to go from having classes on a Thursday to a Sunday for example??i would like to ask if the N.Recurrence is Monthly and say the date is 25th of the month, could there be a possibility that the 25th is a Monday and it happens to clash with a Weekly booking that is on a Monday also? Currently, my understand of your method is that if N.recurrence is either a weekly or monthly i will only check for R.recurrence with weekly or monthly.
Montana has cold dark nights. Perfect for the heat from incandescent light. Tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
|