topic Re: Date for a given Week in Application Development and Automation Discussions

Date for a given Week

Former Member — Thu, 13 Jul 2006 09:55:38 GMT

how can i get the start date and end date for a given week

like if i give week no. 28 then it will return the dates of the week like

start date = 10-07-2006

end date = 16-07-2006.

abhishek

Re: Date for a given Week

Former Member — Thu, 13 Jul 2006 09:57:03 GMT

Hello,

U can try with this FM DAY_IN_WEEK

If useful reward points.

Regards,

Vasanth

Re: Date for a given Week

Former Member — Thu, 13 Jul 2006 09:58:01 GMT

hi,

Check FM <b>DAY_IN_WEEK</b>

CALL FUNCTION 'DAY_IN_WEEK'
EXPORTING
DATUM = P_DATE
IMPORTING
WOTNR = DAY_NUM.

IF DAY_NUM <> 1.
MESSAGE I000(ZICPR).
LEAVE LIST-PROCESSING.
ENDIF.

Check date section of

http://www.geocities.com/victorav15/sapr3/abapfun.html

Regards,

Santosh

Re: Date for a given Week

naimesh_patel — Thu, 13 Jul 2006 09:58:52 GMT

Hello,

For first date : WEEK_GET_FIRST_DAY

Give input as 200628.

FOr last date = first date + 6.

Regards,

Naimesh

Re: Date for a given Week

oliver — Thu, 13 Jul 2006 10:00:27 GMT

Hi Abhishek,

try using function group SCAL and in it FM like this:

call function 'DATE_GET_WEEK'

exporting

date = date_in

importing

week = week

exceptions

date_invalid = 1

others = 2.

call function 'WEEK_GET_FIRST_DAY'

exporting

week = week

importing

date = date_out

exceptions

week_invalid = 1

others = 2.

Last day of the next week you can get by just SUBTRACT 1 FROM date_out of next week.

Hope that helps,

Oliver

Re: Date for a given Week

dani_mn — Thu, 13 Jul 2006 10:02:44 GMT

WEEK_GET_FIRST_DAY

week = '200628'.

It will return the first date.

last_date = first_date + 6.

Regards,

Wasim Ahmed

Re: Date for a given Week

Former Member — Thu, 13 Jul 2006 10:08:06 GMT

Hi,

You can use the FM <b>GET_WEEK_INFO_BASED_ON_DATE</b>

                                                   
  Import parameters               Value            
                                                   
  DATE                            07/13/2006                                                                                
Export parameters               Value            
                                                   
  WEEK                            200628           
  MONDAY                          07/10/2006       
  SUNDAY                          07/16/2006

Regards

vijay