If the purpose of getDate is to return today's date, then:
SQL: Look in the localsql.hlp file found in the BDE
directory. Nope, nevermind, that file is useless for this
question (from what I can tell). I have no idea. Perhaps
someone who does will happen by...
FWIW, a test (turning a QBE into an SQL query) implies that
there is no such option (it converted TODAY into
> I need to be able to bring data for the present day from a paradox 4
> table into SQL Server 2000 (hopefully using DTS). I need to know the
> corresponding paradox function that would be equivalent to the
> getDate() function in T-SQL or PL-SQL.
> Here is roughly what I'm attempting to do in DTS:
> select * from ASSIGN
> where Frdate BETWEEN GETDATE() -2 AND GETDATE() +1
> order by Frdate
> Adam Stretch