Date query

[CSOP]

Hi

I'd like to know if there is an option where i could compare a specific date with the most recent date as the days change ie a non static variable.

Is there a variable like this (ie which acts like a calender and compares my selected feild with the changing days)?

eg.
select *
from table1
where myDateVariable < mostRecentDate

Is this too far fetched?

Many thanks

 

[Sashanan]

If by most recent date you mean today, GetDate() will retrieve the current system date.


&quot;Much that I bound, I could not free. Much that I freed returned to me.&quot;
(Lee Wilson Dodd)

 

[CSOP]

Thankyou your an absolute star