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)
Hi
I would want to set up the following. Database is Oracle.
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 (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 (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 (BOB member since 2002-08-08)