topic Re: Date logic in Application Development and Automation Discussions

Date logic

Former Member — Wed, 18 Jun 2008 06:39:25 GMT

Hi all,

How to abtain friday of every week.

Regards,

Srik

Re: Date logic

Former Member — Wed, 18 Jun 2008 06:40:43 GMT

Means? can you please elaborate?

Re: Date logic

Former Member — Wed, 18 Jun 2008 06:41:41 GMT

Hi,

DAY_IN_WEEK is the functio nmodule, which will return the day of the week.

Pass sy-datum to this fm and check for the day '5'. If it is '5', it's friday.

If not some ohter day.

Reward if helpful,

RSS

Re: Date logic

Former Member — Wed, 18 Jun 2008 06:42:13 GMT

hi,

I want to run the report on weekly basis like every friday of the week.

Regards,

Srik

Re: Date logic

Former Member — Wed, 18 Jun 2008 06:45:31 GMT

Ye then the FM day_in_week is useful

FUNCTION DAY_IN_WEEK.

*"----

""Lokale Schnittstelle:

*" IMPORTING

*" VALUE(DATUM) TYPE D

*" EXPORTING

*" VALUE(WOTNR) TYPE P

*"----

PERFORM DAY_IN_WEEK USING DATUM

CHANGING WOTNR.

pass the date over here

if value is 5 execute ur report

Hope it helps

Re: Date logic

Former Member — Wed, 18 Jun 2008 06:46:28 GMT

Sric,

use FM DAY_IN_WEEK pass sy-datum in date field and

if result is *5* means today is friday than do nothing
else.
pass error message
endif.

Amit.

Re: Date logic

Former Member — Wed, 18 Jun 2008 07:25:48 GMT

Hi,

You can use Code or Function module :

DATA:  WOTNR TYPE P.

   DATA: DIW_FIRST TYPE D VALUE '19790101'.

   PARAMETERS: p_date type D.

   WOTNR = ( ( p_date - DIW_FIRST ) MOD 7 ) + 1.

   WRITE:  WOTNR.

Or FM

DAY_IN_WEEK.

You use the logic that if day is 5( ie o/p of above FM) schedule a job.

This will surely help you.

Plz reward if useful.

Thanks,

Dhanashri.

Re: Date logic

Former Member — Fri, 20 Jun 2008 09:49:51 GMT

Hi Srik,

If your problem is solved, please reward teh points and close the thread.

RSS.

Re: Date logic

Former Member — Wed, 08 Feb 2012 09:25:42 GMT

done