How do I go about checking to see if the current date is between two other dates?
I've been trying different operators, but haven't been able to figure this out.
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?