Board index » off-topic » Get System Date in Paradox

2005-06-22 08:43:35 PM
off-topic8
How can i get system date in paradox?
I'm trying to compare a date field with system date; something like that:
'select...... where date_to_compare < system_date'
I've tried to get system_date with TODAY and NOW functions but both
report me an error.
Thanks
 

When you say "in Paradox" do you mean in the Paradox for Windows
ObjectPAL language? If so, you will have better luck asking in the
Paradox for Windows support newsgroups.
--
Bill Todd (TeamB)
 

Local SQL in Paradox does not have a systemdate function. You have to use
ObjectPAL and assign it to a variable that can be used as a tildevariable in
the SQL statement.
--
Bertil Isberg - CTECH
Paradox buglist:
online: web.comhem.se/~u82608896/
 

{smallsort}