Hello Ed, Jeff

Thank You

Gomonth()

I will remember that one!

Thanks Again!!
R D Black

>>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!