I have a script where I would like to check for todays date.

I want to say in a where condition

where end.date < todays date

I have tried

where end.date < date()
where end.date < date.num()

but it still doesn't work. Can anyone help me with the syntax?

You would need to declare a variable say curr.date and assign date.num() to that var. And then use this variable in the query.


domain tcdate curr.date

curr.date = date.num()


where end.date < :curr.date


Hope this helps.

Manish.