SQL errors out on date functions

[maccrystal]

Version 6.7 Dbase:
SQL querys that use date function returns error. If you remove the Date(), Date()-30 or getdate() and sub "01/01/2006" the query works.

Invalid use of keyword.

Context: SQLQuery:
select company, contact, lastconton, lastuser,contact1.ACCOUNTNO from contact1, contact2 where contact1.accountno = contact2.accountno and Lastconton < (Date()-30)

1: Line Number: 1
2: Token: Date()

BDE Error Cat:Code: [42:18]
BDE: 500 [11/5/1901] GoldMine: 6.70.50123

http://www.appstratinc.com

 

[RobColborne]

Hi

Because it's a dBase system it doesn't support all the keywords used by SQL, so hence date(), getdate() etc doesn't work.