Rolling 6 Weeks Filter & Sysdate Prompt

Hi

I would want to set up the following. Database is Oracle.

Rolling 6 weeks Filter

Prompt showing a drop down of the last 3 days

Please do let me know.


r_kishore (BOB member since 2002-08-20)

The Rolling 6 Weeks is fairly easy. Create a Predefined Condition with the following:

Table.DateField >= TRUNC(Sysdate)-42

The 42 represents 42 days ago, which is, of course, 6 weeks.


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

Michael

Thanks!

Yes. This takes me to the mid of that week. I want previous full 6 weeks.

Please do let me know


r_kishore (BOB member since 2002-08-20)

Hi,

You’d have to do a DECODE or CASE…WHEN and vary the number of days to subtract, based on the current day.

Judy


JMulders :us: (BOB member since 2002-06-20)

I don’t have my Oracle guide with me, but I believe this will work:

Table.DateField >= TRUNC(Sysdate,'w')-42 AND Table.DateField < TRUNC(Sysdate,'w')

The ‘w’ will trunc your sysdate to the beginning of the current week, and -42 will take you six weeks before that. You might want to double check that ‘w’ to make sure that’s the right syntax, but I think it will work.


MichaelWelter :vatican_city: (BOB member since 2002-08-08)