DateSerial and IIF Statements

[mindbender]

I am trying to look for data within the current month, next month and next month after that (30, 60, 90)

I have this piece working so far and if the order date falls within current month the report was run in it sets the field to 30 day and sets all others to EXPIRED


MPL_Range: IIf([OPTY_PROD]![Order Date] Between (DateSerial(Year(Date()),Month(Date()),1)) And (DateSerial(Year(Date()),Month(Date())+1,0)),'30
Day','EXPIRED')

When I try to add the other parameters it throws an error of invalid arguments and highlights the character in bold.

MPL_Range: IIf([OPTY_PROD]![Order Date] Between (DateSerial(Year(Date()),Month(Date()),1)) And (DateSerial(Year(Date()),Month(Date())+1,0)),'30
Day',IIf([OPTY_PROD]![Order Date] Between (DateSerial(Year(Date()),Month(Date()),+1,1)) And (DateSerial(Year(Date()),Month(Date())+2,0)),'60
Day','EXPIRED'))

I am basically trying to get it to say if the order date is in the current month set it to 30 Day, if the order date is in the next month set it to 60 Day, if the order date is in the next month after that set it to 90 Day else EXPIRED

Please Help

[June7]

Try:

MPL_Range: IIf(Format([Order Date],"yyyymm") = Format(Date(),"yyyymm"), "30 Day", IIf(Format([Order Date],"yyyymm")=Format(DateAdd("m",1,Date()),"yyyymm"), "60 Day", IIf(Format([Order Date],"yyyymm")=Format(DateAdd("m",2,Date()),"yyyymm"), "90 Day", "EXPIRED")))

[mindbender]

that worked awesome!!! thank you very much