Weekdays and dates

[Former Member]

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,

PJ

[Former Member]

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.')

[andreas_mann3]

Hi,

combine fm <b>WFCS_FCAL_WDAYS_GET_S</b> (get workdays)

and fm <b>DAY_IN_WEEK</b> (nr. of the day)

Andreas

[Former Member]

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?

[andreas_mann3]

sorry PJ,

it's <b>WFCS_FCAL_LUT_CREATE_S</b>

regards Andreas

[Former Member]

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