Maybe a simple question, but i do not know how to put the current date in the WHERE clause of a SQL query.
The query i have so far:
After this there has to be something like
I know that with Date() or Now() the expression can be made, but i do not know how, please advise..
Thanks in advance
The query i have so far:
Code:
select [table1].*, [table2].* from [table1], [table2] where [table1].[field] = [table2].[field] and [table1].[enddate] is null
After this there has to be something like
Code:
and [table1].[begindate] < [Date] (where [date] is the expression)
I know that with Date() or Now() the expression can be made, but i do not know how, please advise..
Thanks in advance