Quote:
Originally posted by red-beard
the second equation works, but you need to use the numeric values for the dates, not the formated version, as it is being interpreted as a math equation instead of a date.
|
yup, that was the problem I wasn't seeing. thanks
here's what I went with:
= IF ( AND ( TODAY ( ) > = DATE ( 2007 , 6 , 1 ) , TODAY ( ) < = DATE ( 2007 , 9 , 15 ) ) , 10% , 0 )