topic Re: FM: Diff between two dates based on factory calender in Application Development and Automation Discussions

FM: Diff between two dates based on factory calender

Former Member — Fri, 13 Jun 2008 05:12:11 GMT

Hi,

Could anybody assist me, My requirement is to determine delay of delivery date is equal to (goods receipt posting date u2013 planned delivery date) based on the Factory calender as well as Pulic holidays i.e it should not consider both.Is there any function module to find out the date diffrence. The difference should be '+' or '-' OR 'ZERO'. I have used function module 'DAYS_BETWEEN_TWO_DATES' but it is not useful.

Thanks in advance.

Regards.

I.Reddy Prasad.

Re: FM: Diff between two dates based on factory calender

Former Member — Fri, 13 Jun 2008 05:19:10 GMT

Hi,

Check these FM's:

HR_HK_DIFF_BT_2_DATES

HR_99S_INTERVAL_BETWEEN_DATES

Regards,

Narasimha

Re: FM: Diff between two dates based on factory calender

Former Member — Fri, 13 Jun 2008 05:19:24 GMT

Hi,

Check these FM's:

HR_HK_DIFF_BT_2_DATES

HR_99S_INTERVAL_BETWEEN_DATES

FIMA_DAYS_AND_MONTHS_AND_YEARS

Regards,

Narasimha

Edited by: narasimha marella on Jun 13, 2008 7:20 AM

Re: FM: Diff between two dates based on factory calender

Former Member — Fri, 13 Jun 2008 05:20:25 GMT

hi there....

i tried with a simple logic.. lets c if this helps...

declare a variable var of type p.

den do

var = date1 - date2.

this will calculater the difference in days and put it in the variable var.

do reward if helpful.

Re: FM: Diff between two dates based on factory calender

GauthamV — Fri, 13 Jun 2008 05:20:31 GMT

hi,

check these func. modules.

CATS_CHECK_FACTORY_DATE

DATE_CONVERT_TO_FACTORYDATE Calendar function: Returns factory calendar date for a date

FACTORYDATE_CONVERT_TO_DATE Calendar function: Returns date for a factory calendar date

LAST_FACTORYDATE_GET Calendar function: Return last factory date for a factory calendar

reward points if hlpful.

Re: FM: Diff between two dates based on factory calender

Former Member — Fri, 13 Jun 2008 05:29:30 GMT

Hi Narasimha,

Thanks for your response. I need to find difference between two dates based on the factory calender.please do the needful.

Thanks and Regards.

I.Reddy Prasad.

Re: FM: Diff between two dates based on factory calender

Former Member — Fri, 13 Jun 2008 05:37:35 GMT

Hi,

CALL FUNCTION 'FI_PSO_DAYS_MONTHS_YEARS_GET'

EXPORTING

i_date_from = gv_budat

i_date_to = gv_eindt

IMPORTING

e_days = gv_diff

e_months = lv_diff_months

e_years = lv_diff_year.

regards

Susheel

Re: FM: Diff between two dates based on factory calender

Former Member — Fri, 13 Jun 2008 05:38:33 GMT

Hi,

Use below logic to solve your problem.

Find the difference between the dates.

g_no_days = date1 - date2.

c_date = date1.

DO g_no_days TIMES.

CALL FUNCTION 'DATE_CONVERT_TO_FACTORYDATE'

Input: Correct option : '+'

Date : c_date

Factory calendat : 'XX'

Output :

Date : c1_date.

If c_date = c1_date.

count = count + 1.

endif.

c_date = c_date + 1. (increase date by 1 day)

ENDDO.

If holidays or weekend occurs, the c1_date will not be same as C_date.

Hope this help you.