Question:
Hi all,
Has anyone an idea how to put a BEx condition on the previous working day?
eg. If I run the report on monday he should return the results of friday.
regards,
Panglea
Answer:
I'm not sure how to do it but I would try creating a variable that is automatically populated.
The logic would be based on current date and day of week.
Where Day_of_week(system_date) is
Monday: Prev_working_day=sytem_date-3
Sunday: Prev_working_day=sytem_date-2
esle: Prev_working_day=sytem_date-1
Jim F.
There are 10 types of people, those who understand binary and those who don't.
Answer:
I don't have an answer to that, only remarks that will give you even more problems...
Jim's idea is only valid if you consider that mon-tue-wed-thu-fri are the working days;
depending on the company, saturday could also be a working day;
if friday was a legal holiday, the result should be thursday;
to cope with that, you have to work with the concept of factory calendar;
but I don't know how to handle it in Bex
I have the same kind of problem, as I want to calculate a number of working days between two dates based on the factory calendar. At loading time using abap, it's peanuts. At query runtime, it's a pain.
Ch