get current date from external data

[toshimatulis]

Hi all,

I use the "import external data" create "new database query"

SELECT dbo.Ino.InoNum, dbo.Ino.ReqLo
FROM dbo.Ino FULL OUTER JOIN dbo.TBLAREA ON dbo.Ino.Area =
dbo.TBLAREA.integ

WHERE (dbo.Ino.KeyCode = 'MESI') AND (dbo.Ino.[Date] =
'11/06/2003') AND (dbo.TBLAREA.area ='SNMT-01')


I only need to display the current date and to do that i always change
the date manually "(dbo.Ino.[Date] = '11/06/2003')"

Is there a another way i could display the current date automatically?
Thanks!