a single script step:
Set Field [ field1 ; If ( date_applied > 01/01/2008 and date_applied < 06/30/2008 ; 100 ; 150 ) ]
Your English looks great to me. Thanks for the help. Its working better in that the fields are populating, but they are always populating with a FALSE. The date_ma_needed field is definitely a date field and is always required. I created a layout with all my fields on it in simple form view and for the field date_ma_needed I entered 06/01/2009.
Here is the script
Set Field [RESIDENT::MAINT_pna; If (RESIDENT::date_ma_needed > 01/01/2009 and RESIDENT::date_ma_needed < 06/30/2009;45;0)]
The answer I got was 0 even though the date entered (06/01/2009) should have responded with 45.
Thanks for any insight you may have
Set Field [RESIDENT::MAINT_pna; If ( RESIDENT::date_ma_needed > Date ( 1 ; 1 ; 2009 ) and RESIDENT::date_ma_needed < Date ( 6 ; 30 ; 2009 ) ; 45 ; 0 ) ]