Try changing the DATE() to either NOW() or TODAY(). In Fox, DATE() returns the current system date.
TODAY() does the same in Excel. Hope it works for you.
I don't use MS Query. I find it easier to send the data to Excel from FoxPro.
Tom Molloy
>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"?
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement