topic Re: Direct function module to convert YEARWEEK to YEARMONTH in Application Development and Automation Discussions

Direct function module to convert YEARWEEK to YEARMONTH

Former Member — Thu, 24 Nov 2011 04:43:58 GMT

Hi Experts ,

I have been googling to finad a direct function module to convert given yearweek (201104) to yearmonth(201101) . But i couldn't find anywhere i hope some body can surely help me regarding this .

currently i am using VELO03_WEEK_OR_MONTH_TO_DATE to get the date from the given year,week and then calculating the month. but There is a risk that i may not get the correct YEARMONTH from this.

Please give me the solution for this problem . the best solution will be greeted with the best.

thanks in advance .

Re: Direct function module to convert YEARWEEK to YEARMONTH

Former Member — Thu, 24 Nov 2011 05:47:07 GMT

Hi,

maybe fm WEEK_GET_FIRST_DAY can help you to get your month.

For emaple pass 201117 for week 17 to it, and you get the 25th of April, so your month of the 1st day will be April, but note, that the month of the week's last day will be May.

Regards,

Klaus

Re: Direct function module to convert YEARWEEK to YEARMONTH

Former Member — Thu, 24 Nov 2011 06:12:09 GMT

Thank you Klaus.

That is the problem here Klaus ,see for the week 17 we are getting two months APRIL & MAY here which one to select. Is there any function module to calculate directly from YYYYWW to YYYYMM .

Re: Direct function module to convert YEARWEEK to YEARMONTH

kesavadas_thekkillath — Thu, 24 Nov 2011 06:14:46 GMT


see for the week 17 we are getting two months APRIL & MAY here which one to select. Is there any function module to calculate directly from YYYYWW to YYYYMM .

Generally the start date of the week is considered in the industries i worked for. You have to confirm with your people.

Kesav