topic Re: Get the date range in Application Development and Automation Discussions

Get the date range

Former Member — Thu, 04 Jun 2009 08:52:08 GMT

Hi,

There is a requirement that we need to get date range.This date range will be arrived at using the function module BKK_GET_PRIOR_WORKDAY. The factory calender id is GB. It should return the date range. Therefore, for weekends the date range will be Saturday, Sunday and Monday. The date range will change based on holidays that exist in the holiday calendar.

Now my question is how to calculate that there are two days between friday and monday.

Please help.

Re: Get the date range

Former Member — Thu, 04 Jun 2009 09:02:26 GMT

Hi Nishigandha,

If i am correct you need the number of days between two dates

ex:

date1: 04/06/2009

date2: 12/06/2009

you need the number of days??

then probably check this Fm out:

SD_DATETIME_DIFFERENCE this is a function module which gives the difference in Days and Time for entered two dates

P.S Additionally Chk this out:

/people/mustafabaris.gunes/blog/2009/03/16/calculating-number-of-working-days-in-query-level

Hope its useful

Thanks and Regards

Srikanth.P

Edited by: SRIKANTH P on Jun 4, 2009 2:33 PM