topic Re: FM DATE_GET_WEEK giving Error in Application Development and Automation Discussions

FM DATE_GET_WEEK giving Error

Former Member — Thu, 13 Nov 2008 13:09:50 GMT

Dear All,

I'm using the FM DATE_GET_WEEK to convert a Date into a Week.

I gave a Date as 12/28/2008 (MM/DD/YYYY).

The output was 200953.

I think this is absurd. As far as I know there will not be any Calendar week with 53 for the Year 2009.

Is this the Problem with the Fm ?

Is there any SAP note reg. this ?

Request your help !

Thanks & Regards,

Deepu.K

Re: FM DATE_GET_WEEK giving Error

Former Member — Thu, 13 Nov 2008 13:14:59 GMT

Hi Deepu,

I have executed the FM by putting the same input 12/28/2008 which you have put. But my output is different that is '200852'.

I Think you might enter some wrong value. I am pretty sure. check it again.

Thanks,

Chidanad

Re: FM DATE_GET_WEEK giving Error

Former Member — Thu, 13 Nov 2008 13:15:29 GMT

It is giving correct o/p 200852 if i give date as 28.12.2008 in DATE_GET_WEEK function module

Re: FM DATE_GET_WEEK giving Error

Former Member — Thu, 13 Nov 2008 13:15:50 GMT

Indeed is really absurd. But I tried it , gave me 200852. How did you pass the date to the function I passed it as 20081228 ?

regards,

Advait

Re: FM DATE_GET_WEEK giving Error

Former Member — Thu, 13 Nov 2008 13:18:44 GMT

Dear All,

When I pass the Date as 12/28/2008 (MM/DD/YYYY Format) I'm getting the week as 200852.

But when I pass the Date as 12/28/2009 I'm getting the week as 200953.

Regards,

Deepu.k

Re: FM DATE_GET_WEEK giving Error

rthoodi — Thu, 13 Nov 2008 13:19:17 GMT

Hello Deepu,

Fm DATE_GET_WEEK works fine

just provide the date as per your sustem default date

my system default date is DD.MM.YYYY

give the date in the same for mat as 13.11.2008

Answer is WEEK : 200846

Thanks

Edited by: RK on Nov 13, 2008 2:20 PM

Re: FM DATE_GET_WEEK giving Error

Former Member — Thu, 13 Nov 2008 13:30:35 GMT

Hello RK,

Did u check with MM/DD/YYYY Format and with the Date as 12/28/2009 ?

Let me know what value u r getting for the above params !

Regards,

Deepu.k

Re: FM DATE_GET_WEEK giving Error

Former Member — Thu, 13 Nov 2008 13:34:51 GMT

Hello,

Year 2009 has 53 weeks. FM is returning the correct values. Have checked the same.

Thanks,

Jayant

Re: FM DATE_GET_WEEK giving Error

Former Member — Thu, 13 Nov 2008 13:35:17 GMT

Yes , you are right it does give 200953 for that date. But it is correct. If you notice your outlook calendar , you will see that the week starting from 28th December has week number 53.

regards,

Advait

Re: FM DATE_GET_WEEK giving Error

rthoodi — Thu, 13 Nov 2008 13:40:02 GMT

Hello Deepu,

Iam sorry , Iam not able to change my defalut parameters, If I give the date 12/28/2009 , system not accepting and it returns an error message like enter valid value.

For date 28.12.2009 , Iam getting Week 200953.

Thanks

Edited by: RK on Nov 13, 2008 2:40 PM

Re: FM DATE_GET_WEEK giving Error

RaymondGiuseppi — Thu, 13 Nov 2008 13:42:26 GMT

2009 has 53 weeks, As the first week of a year is the week that contains the first Thursday of a year. In 2009 this is january 1st, in 2010 this will be januaty 7th, so the last week of 2009 will be the 53th. (the week of 2009 begins with 2009.01 monday 12/29/2008 end ends with 2009.53 sunday 01/03/2010, a long year)

(Look at [ISO week date at wikipedia|http://en.wikipedia.org/wiki/ISO_week_date])

Regards

Re: FM DATE_GET_WEEK giving Error

former_member156446 — Thu, 13 Nov 2008 13:44:45 GMT

if the date value is in cell B4 of an excell doc

=INT((B4-DATE(YEAR(B4-WEEKDAY(B4-1)4),1,3)WEEKDAY(DATE(YEAR(B4-WEEKDAY(B4-1)4),1,3))5)/7) formula gives the week number.

DATA: date         LIKE scal-date,
      week         LIKE scal-week.
CALL FUNCTION 'DATE_GET_WEEK'
  EXPORTING
    date         = sy-datum
  IMPORTING
    week         = week
  EXCEPTIONS
    date_invalid = 1.
WRITE / week.

output:200846

Re: FM DATE_GET_WEEK giving Error

Former Member — Thu, 13 Nov 2008 13:49:48 GMT

Hello Raymond,

Thanks for the reply.

Regards,

Deepu.K

Re: FM DATE_GET_WEEK giving Error

Former Member — Thu, 13 Nov 2008 13:54:58 GMT

Hello Deepu,

There were many other correct replies in the thread too... not just 1 (and that too in last).

Thanks,

Jayant

Re: FM DATE_GET_WEEK giving Error

Former Member — Thu, 13 Nov 2008 13:58:58 GMT

Yes Jayanth,

U r right ! But the Reply with reasoning which is suitable for the Queries scenario will be appreiciated !

Anyways ...credit is given

Regards,

Deepu.k

Re: FM DATE_GET_WEEK giving Error

Former Member — Thu, 13 Nov 2008 14:02:55 GMT

Thank you Deepu, We should always be thankful to all the people replying to your post. This should be the best practice to make SDN Best. Thank you for your understanding.

Thanks,

Jayant