VARIABLE EXIT sunday as low value and saturday as high value

26 Views

Hi Gurus,

We have a requirement to show report in the following order...

the user runs the report on a week day, the report variable should be filled with

earlier week sunday as low value and saturday as high value

QUERY WEEK WEEK WEEK

RUNDAY DAY LOW HIGH

28/10/07 SUN 21/10/07 27/10/07

29/10/07 MON 21/10/07 27/10/07

30/10/07 TUE 21/10/07 27/10/07

31/10/07 WED 21/10/07 27/10/07

01/11/07 THU 21/10/07 27/10/07

02/11/07 FRI 21/10/07 27/10/07

03/11/07 SAT 21/10/07 27/10/07

04/11/07 SUN 28/10/07 03/11/07

05/11/07 MON 28/10/07 03/11/07

PLS OBSERVE LAST TWO ROWS CLEARLY...

Low Value: Always default to the prior Sundays date

High Value: Always default to the prior Saturdays date

This is the query logic and if anyone came accross this logic,

can you send me the code for the customer exit for this logic or

any help regarding the same will be heartly appreciated.

thanks in advance

Hemanth