JSR Dates

I’m trying to create an AutoIndex where I need to compare the current date with a field of the content item in order to form the list.

How do I get the current date in JSR? Something equivalent to Oracle’s SYSDATE?

Try passing the date to the slot:

In the template bindings add a variable such as $params.date and set that to $tools.date.getDate() and then pass the params to the slot in your template:
#slot(‘SlotName’ ‘’ ‘’ ‘’ ‘’ $params)

And use the date parameter in the JSR query: SELECT rx:sys_contentid FROM rx:[Content] WHERE rx:date_field >= :date

Thanks, Jason, exactly what I wanted to know. Got it working perfectly now.