I have to check whether a given date is between a day and a month.
A guided tour is only scheduled from november 1st until april 1st.
when i want to make a reservation for the tour Today the query should
tell me that today is out of range.
In the database we store this as seperate fields:
from day integer 1 to 7
from month integer 1 to 12
till day integer 1 to 7
till month integer 1 to 12
when Today is between november 1st and march 30 then NoGood
when Today is not between november 1st and march 30 then Proceed
I have tried a number of variations but without any results yet.
I hope someone can give a tip on how to solve this particular case
Many thanks in advance
eddy