topic error with DAYS_BETWEEN_TWO_DATES FM in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/error-with-days-between-two-dates-fm/m-p/7651746#M1573199 <HTML><HEAD></HEAD><BODY><P>I am using the FM DAYS_BETWEEN_TWO_DATES, however it is not working as expected....</P><P></P><P>My code looks like this:</P><PRE><CODE> CALL FUNCTION 'DAYS_BETWEEN_TWO_DATES' EXPORTING i_datum_bis = lw_booked-enddt i_datum_von = lw_booked-strdt i_kz_incl_bis = '1' IMPORTING e_tage = lw_booked-duration EXCEPTIONS days_method_not_defined = 1 OTHERS = 2. </CODE></PRE><P></P><P>the data looks like this once converted using this FM (start date / end date / duration)...</P><P></P><P>15.10.2011 17.10.2011 3.00</P><P>03.10.2011 04.10.2011 2.00</P><P>13.10.2011 15.10.2011 3.00</P><P>06.10.2011 09.10.2011 4.00</P><P>22.10.2011 24.10.2011 3.00</P><P>20.10.2011 21.10.2011 2.00</P><P>22.10.2011 24.10.2011 3.00</P><P>28.10.2011 01.11.2011 4.00</P><P></P><P>all the entries, but the last entry are correct using this FM!</P><P>the 28.10.2011 - 01.11.2011 is 5 days - not 4... if i can't rely on standard SAP FM.. what can i use instead???</P></BODY></HTML> Wed, 09 Feb 2011 12:10:17 GMT Former Member 2011-02-09T12:10:17Z error with DAYS_BETWEEN_TWO_DATES FM https://community.sap.com/t5/application-development-and-automation-discussions/error-with-days-between-two-dates-fm/m-p/7651746#M1573199 <HTML><HEAD></HEAD><BODY><P>I am using the FM DAYS_BETWEEN_TWO_DATES, however it is not working as expected....</P><P></P><P>My code looks like this:</P><PRE><CODE> CALL FUNCTION 'DAYS_BETWEEN_TWO_DATES' EXPORTING i_datum_bis = lw_booked-enddt i_datum_von = lw_booked-strdt i_kz_incl_bis = '1' IMPORTING e_tage = lw_booked-duration EXCEPTIONS days_method_not_defined = 1 OTHERS = 2. </CODE></PRE><P></P><P>the data looks like this once converted using this FM (start date / end date / duration)...</P><P></P><P>15.10.2011 17.10.2011 3.00</P><P>03.10.2011 04.10.2011 2.00</P><P>13.10.2011 15.10.2011 3.00</P><P>06.10.2011 09.10.2011 4.00</P><P>22.10.2011 24.10.2011 3.00</P><P>20.10.2011 21.10.2011 2.00</P><P>22.10.2011 24.10.2011 3.00</P><P>28.10.2011 01.11.2011 4.00</P><P></P><P>all the entries, but the last entry are correct using this FM!</P><P>the 28.10.2011 - 01.11.2011 is 5 days - not 4... if i can't rely on standard SAP FM.. what can i use instead???</P></BODY></HTML> Wed, 09 Feb 2011 12:10:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-with-days-between-two-dates-fm/m-p/7651746#M1573199 Former Member 2011-02-09T12:10:17Z Re: error with DAYS_BETWEEN_TWO_DATES FM https://community.sap.com/t5/application-development-and-automation-discussions/error-with-days-between-two-dates-fm/m-p/7651747#M1573200 <HTML><HEAD></HEAD><BODY><P>What's wrong with a line of code? Write a line of code that says essentially</P><P></P><P> </P><PRE><CODE>duration = enddate - startdate. or if you want inclusive: duration = ( enddate - startdate ) + 1.</CODE></PRE><P></P><P>Guess I'm biased, but I don't understand why programmers search for and find obscure function modules, code for those and struggle with the results instead of inserting a single line of code! Maybe I'm obsolete...</P></BODY></HTML> Wed, 09 Feb 2011 12:14:45 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-with-days-between-two-dates-fm/m-p/7651747#M1573200 Former Member 2011-02-09T12:14:45Z Re: error with DAYS_BETWEEN_TWO_DATES FM https://community.sap.com/t5/application-development-and-automation-discussions/error-with-days-between-two-dates-fm/m-p/7651748#M1573201 <HTML><HEAD></HEAD><BODY><P>Fixed!</P><P></P><P>needed to set I_SZBMETH = SPACE</P></BODY></HTML> Wed, 09 Feb 2011 12:15:07 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-with-days-between-two-dates-fm/m-p/7651748#M1573201 Former Member 2011-02-09T12:15:07Z