I know I'm missing something easy here... I've been trying different operators, but haven't been able to figure this out...
How do I go about checking to see if the current date is between two other dates?
So, if I have a from date of 2/2/2010 and a to date of 2/10/2010, how can I return TRUE if the current date (2/4/2010) falls between those two dates?