topic Re: Weekdays and dates in Application Development and Automation Discussions

Weekdays and dates

Former Member — Mon, 25 Jul 2005 06:14:21 GMT

hi all,

i have the following two requirements. Please let me know if there are any function modules for the same.

1) I have a From-Date and a To-Date. Within this interval i want to find all the nth days of week. for example for n = 2, i want the dates for all mondays within this period.

2) again for the interval (from-to date) i want the dates on the nth weekdays. for example, for n = 4 and weekday = 2, then i want dates for all 4th mondays of month within the period.

(of course this means that the period will span for more than one month for the second requirement while for the first it can span for more than one week)

regards,

Re: Weekdays and dates

Former Member — Mon, 25 Jul 2005 06:16:27 GMT

Hi,

Try this one

DATE_COMPUTE_DAY Returns day of the week for a particular date(1=Monday, 5=Friday etc.)

DATE_TO_DAY Returns day of the week for a particular date('Monday', 'Friday', 'Sat.')

Re: Weekdays and dates

andreas_mann3 — Mon, 25 Jul 2005 06:35:07 GMT

Hi,

combine fm WFCS_FCAL_WDAYS_GET_S (get workdays)

and fm DAY_IN_WEEK (nr. of the day)

Andreas

Re: Weekdays and dates

Former Member — Mon, 25 Jul 2005 07:05:33 GMT

hey JJS,

Thanx!! ur answer serves well for the first requirement.

Andreas,

i dont think WFCS_FCAL_WDAYS_GET_S is suiting req 2. or m not clear with what its doing? is it returning the number of working days in the specified period? i dont think thats what i require...

could you please explain in detail how u think it can be used?

Re: Weekdays and dates

Former Member — Mon, 25 Jul 2005 07:29:56 GMT

Hi PJ,

Take a look to SE37 and give DAYS as a search value. You'll get plenty of function modules for handling dates.

Regards,

Ville

Re: Weekdays and dates

andreas_mann3 — Mon, 25 Jul 2005 08:06:06 GMT

sorry PJ,

it's WFCS_FCAL_LUT_CREATE_S

regards Andreas