>I'm trying to scan a date field for records that are in the month of may 1999 is there a function or comgination of functions to do this?
>

several ways to do this - I'd use BETWEEN(), as in:

dBeginDate = {^1999-06-01}
dEndDate = GOMONTH(dBeginDate,1) - 1

SCAN FOR BETWEEN(dMyDateFld, dBeginDate, dEndDate)

an index on dMyDateFld will help performance significantly here.

You could also use DTOS():

cMonthToFind = LEFT(DTOS(dBeginDate),6)

SCAN FOR DTOS(dMyDateFld) = cMonthToFind

an index on DTOS(dMyDateFld) will help performance significantly here.
>Any Help will be greatly appreciated!