cancel
Showing results for 
Search instead for 
Did you mean: 

NATIVE FILTER ON UNIVERSE

0 Kudos

Hi Experts,

We are on BO 4.1 SP6 version.

We have a requirement to create a filter @IDT ( Universe ) with bit of customization.

We have Calendar Day as ( Date ) in our Universe, we need one filter to have date range ( system date - 3 days ) Lets say Today-1, Today-2, Today-3.

We tried using "current_date" , but ! Its returning today's date, we want date range from today till 3 days back.

Please suggest, how to achieve this.

Regards,

Suresh

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member199543
Contributor
0 Kudos

This depends on DB you use , the code might differ, few exampes below:

mssql: table.column between dateadd(day,-3,getdate()) and getdate()

Db2 table.column between current date - 3 days and Current date