Let ( days = date closed - date opened ; If ( days > 60 and days < 120 ; 1 ; 0 ) )
Let ( days = date closed - date opened ; case ( days > 60 and days < 120 ; 1 ; 0 ) )
in both cases "; 0" could be omitted and you'd get the same results.
okay I did finally figure it out however I am having trouble with a script and I think its an error I have made before.
This is what I have trying to set 3 global fields for my search
set error capture
go to layout
enter find mode
set field [DCIU::Date complaint closed; DCIU::gstartedate & "..." &DCIU::genddate]
new record request
set field[DCIU::gfunctional area]
I don't see the connection between that script and your original post.
Your script should find all records in a given date range. The calculation simply flags all records that fall in the specified range with the value 1.
You also appear to be missing a parameter from the second set field script step.