Function WhichDate(wDate as Date) as Long
Const myDate1 as Date = 07/01/2002
Const myDate2 as Date = 06/30/2003

If wDate myDate1 And wDate < myDate2
WhichDate = 1
Else
WhichDate = 0
End If

End Function
-----Original Message-----
i want to know the syntax for an if statement

i want the if statment to generate a "1", if the dates
fall within the range
07/01/2002 - 06/30/2003 , if not, then "0"

thanks


.