wrightyrx7
Well-known Member
- Joined
- Sep 15, 2011
- Messages
- 994
Im trying to think of the best way to check if a date range contains 01 November.
If it was a static date i would just use <= AND >= on the start and end date.
However, this is just 01 November with NO set year. If the 01 November is within the Start and End date (including the start and end date themselves) then im going to try and split the row so one runs until 31/10 then the new one starts 01/11. So if the date rage DOES contain 01/ November it would be good if i could find out which YEAR it is.
If it was a static date i would just use <= AND >= on the start and end date.
However, this is just 01 November with NO set year. If the 01 November is within the Start and End date (including the start and end date themselves) then im going to try and split the row so one runs until 31/10 then the new one starts 01/11. So if the date rage DOES contain 01/ November it would be good if i could find out which YEAR it is.
Last edited: