Current Date

[Ashkan]

I have a table named Contracts. It has the fields Contract ID, Contract Start Date, Contract End Date.

I need to be able to produce a query that will contain all current contracts.

Any ideas???

Thanks
Ashkan

 

[namliam]

"simple"

Select
from Contracts
where [Contract Start Date] <= date()
and ([Contract End Date] >= date() or [Contract End Date] is null)

 

[Ashkan]

Thank you