>problem with sytax, this statement isn't working, are my brackets in wrong spot?
>
>replace all May_1998 with 2 for May_1998 = 0 and ((start_da < {1998/06/01}) and (final_da > {1998/05/01}))
>
>thanks in advance.
Instead of the braces I would use start_da < CTOD('06/01/1998') etc..
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope