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

Thanks,

Adam Stretch

If the purpose of getDate is to return today's date, then:

ObjectPAL: date()

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
'01/09/2002').

Liz