trying to query VFP for orders in Current Month

[Vornadofan]

Hi,
I have an Access database that is linked to a VFP table and some SQL tables. When I query orders for the month in the SQL tables I can use Month(Now()) in Access. That does not work on the VFP table. What is the proper systax to query for the Current Month with the VFP table?
Thank you!

 

[SkipVought]

Hi,

Try Date()

Skip,
[sub]
[red][/red]
[/sub]