>replace all May_1998 with 2 for May_1998 = 0 AND ((start_da < {1998/06/01}) and (final_da > {1998/05/01}))

What are you trying to do Sheena? you need to follow the replace syntax after the AND(some_fieldname WITH some_value).

Looks like your trying to make the part after the AND conditional, if so where's your IIF() in there?


Like maybe...
replace all May_1998 with 2 for May_1998 = 0 AND (IIF(start_da < {1998/06/01} and final_da > {1998/05/01}, some_value, other_value)