I want to return a value based on a date being within a date range. For example, if a date is between 01/01/12 and 01/31/12, the expression returns "1", if the date is between 02/01/12 and 02/29/12 , then "2", etc. I am using: IIf([ActualPickupDate]=Between #01/01/12# And #01/31/12#,1, IIf([ActualPickupDate]=Between #02/01/12# And #02/29/12#,2,... And #12/31/12#, 12,""))))))))))))
I keep getting syntax errors. Any suggestions?
Thanks