Convert SQL expressions to dBase expressions?
Posted on 2006-10-20
Need to write some simple dBase expressions for a filter in Goldmine to filter all records that have been updated in the last year. I can struggle thru them in SQL, but Goldmine has to have a dBase equivalent expression to make it work.
Here's what I have in SQL:
WHERE c1.LASTDATE >= DATEADD(dd,-365,GETDATE())
Is there any software that could take an SQL expression like this & show me the dBase equivalent?