I'm unable to select records of the last 30 days.

I want my query to always return all records of the last 30 days. This statement works in Microsoft Visual FoxPro 5. Yet Microsoft Query "Stops Responding" when trying to finish reading the records from my VFP table.

SELECT vhtckpop.* FROM vhtckpop vhtckpop WHERE (vhtckpop.mfgdate>DATE()-30)

Other VFP functions work well within MSQuery's SQL Dialog Box, at least within the fieldlist.

Is there some other way to specify "Always the last 30 days worth of data"?