2010 Feb 17 6:49 AM
Hi All,
I am developing a customer exit to get Last Year's associated week from Current date(SY-DATUM). While doing this I am not able to convert my current fiscal week to associated last year's week.
For example if I run the report on 17/02/2010 which is 47th week for Fiscal year 2010. Now I want to have corresponding week for Last Year.
Please help me resolve this....
Thanks a ton in advance...
Vikrant
2010 Feb 19 4:21 PM
So, now that you know that you're in the 47th week of fiscal year 2010, you must have used a function module to get that information.... What I would do is look for the reverse...a function module that returned the start and end of week 47 for fiscal 2009. That FM probably exists...although I'm sorry I can't tell you which one to use.
2010 Feb 19 4:21 PM
So, now that you know that you're in the 47th week of fiscal year 2010, you must have used a function module to get that information.... What I would do is look for the reverse...a function module that returned the start and end of week 47 for fiscal 2009. That FM probably exists...although I'm sorry I can't tell you which one to use.
2010 Feb 19 11:55 PM
Hi Vikranth,
as we have different definitions on week numbering (MS Excel does not know that week 1 not week 2 started january 4 2010) it is just the same thing.
I would create my own method to return the week, start January 1st and step forward until I get the same date and now know the week.
You should take care of February 29th when determining same date last year.
Regards,
Clemens