on 07-09-2010 11:02 AM
Hi,
Please let me know as to how can i derive the 1st day and last day of the fiscal week. I have the fiscal week data eg: 201004 in the cube
Also how can i derive the 1st day and last day of the fiscal year quarter. I have the fiscal quarter data eg: 20101 in the cube
any function module to get the 1st day and the last day of this week and the quarter?
regards,
Mahesh
Hi Mahesh,
Use Function Module WEEK_GET_FIRST_DAY to get the first day of the given week.
You can get the last day of the week by Adding 6 to it OR y using Same function module for next week and get first day of the next week. and Make it - 1.
Regards,
Pratap Sone
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
8 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.