Most efficient way to check if a date falls between two dates?
- by Dave Jarvis
Given:
Start Month & Start Day
End Month & End Day
Any Year
What SQL statement results in TRUE if a date lands between the Start and End days?
1st example:
Start Date = 11-22
End Date = 01-17
Year = 2009
Specific Date = 2010-01-14
TRUE
2nd example:
Start Date = 11-22
End Date = 11-16
Year = 2009
Specific Date = 2010-11-20
FALSE
…
