Topic: How to Use the DaysBetween function in select sentence?
I want to query the record that Days Between <=30days ,so I use the script ,but there is a error :NO such function DaysBetween.How can I use the function correctly?
form2.TableGrid1.dbSQL := ('select name,indate from maintable where DaysBetween(now,indate)<=30 ')