topic Re: Count weeks between 2 dates in Application Development and Automation Discussions

Count weeks between 2 dates

Former Member — Mon, 25 Aug 2008 08:15:42 GMT

Hi all

is there a FM to count weeks between 2 dates? For ex. I should have know how many weeks are between 10-November 2008 and 20-Februara 2009.

Thank you

Herbert

Re: Count weeks between 2 dates

Former Member — Mon, 25 Aug 2008 08:19:09 GMT

check this fm

HR_IE_NUM_PRSI_WEEKS

Return the number of weeks between two dates.

Re: Count weeks between 2 dates

Former Member — Mon, 25 Aug 2008 08:20:29 GMT

Hi.

U try this function module...

DATE_GET_WEEK

Regards:

Prabu

Re: Count weeks between 2 dates

bpawanchand — Mon, 25 Aug 2008 08:23:11 GMT

Check this snippet

DATA :
  w_d1 TYPE sy-datum,
  w_d2 TYPE sy-datum,
  w_temp TYPE i,
  w_week TYPE i..

w_d1 = '20080801'.
w_d2 = sy-datum.
w_temp = w_d2 - w_d1.

w_week  = w_temp DIV 7.

WRITE :
  / w_week.

Regards

Pavan

Re: Count weeks between 2 dates

former_member585060 — Mon, 25 Aug 2008 08:29:02 GMT

Try this FM 'ISP_COUNT_WEEKS_ROUND_DOWN'

Re: Count weeks between 2 dates

Former Member — Mon, 25 Aug 2008 08:35:04 GMT

HR_99S_INTERVAL_BETWEEN_DATES: Difference between two dates in days, weeks, months

Re: Count weeks between 2 dates

Former Member — Mon, 25 Aug 2008 08:35:59 GMT

Hi,

Check this FM,

HR_99S_INTERVAL_BETWEEN_DATES

Regards

Adil

Re: Count weeks between 2 dates

Former Member — Mon, 25 Aug 2008 08:40:43 GMT

Hi,

We can use "HR_99S_INTERVAL_BETWEEN_DATES" function module.

hope this helps.

thanx,

dhanashri.

Re: Count weeks between 2 dates

Former Member — Mon, 25 Aug 2008 09:03:44 GMT

HI herbert,

you can calculate the weeks in ayear by the following formula.

first calculate the no of days between two dates.

then apply

data: no_w type i,

no_d type i.

no_d = no_d / 7.

best wishes

prasad

Re: Count weeks between 2 dates

Former Member — Mon, 25 Aug 2008 09:05:03 GMT

Hi,

please go through following piece of code this will help u...

*10-November 2008 and 20-Februara 2009

data: dat1 type PC26W-WEEKS.

data: p_beg type sy-datum.

data: p_end type sy-datum.

data: t_beg type sy-datum.

t_beg = '20080303'.

p_beg = '20081110'.

p_end = '20090220'.

CALL FUNCTION 'HR_IE_NUM_PRSI_WEEKS'

EXPORTING

TAX_YEAR_BEGIN = t_beg

PERIOD_BEGIN = p_beg

PERIOD_END = p_end

IMPORTING

NUM_WEEKS = dat1

EXCEPTIONS
END_LT_START = 1
END_LT_YEAR_START = 2
START_LT_YEAR_START = 3
OTHERS = 4

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

write:dat1.

Thanks & Regards

Ashu Singh