cancel
Showing results for 
Search instead for 
Did you mean: 

Help neede for customer exit

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (1)

Answers (1)

former_member182516
Active Contributor
0 Kudos

Hi MOny,

You can Use WEEK_GET_FIRST_DAY for getting first day of the week.

add +6 days in order to get the last day of the week.