About

How to filter based on the current time in an answer.

You have two objects that store the current time:

• @{system.currentTime} : it's a presentation variables system where you can find the current time
• Current_Date: which is one of BI Server time logical SQL functions. You have also the same for the time and for the timestamp datatype.

You then just need to create an advanced sql filter and put your formula depending of your need.

Articles Related

How to

The last two years:

Time.year >= year(@{system.currentTime} ) - 1

or

Time.year >= year(CURRENT_DATE) - 1