topic Re: function for dates in Application Development and Automation Discussions

function for dates

Former Member — Wed, 03 Oct 2007 03:20:40 GMT

Hi Experts!

i want to calculate months b/w 2 dates , is there function for this . can i find days and year also .plz tell me .

thanks.

Re: function for dates

Former Member — Wed, 03 Oct 2007 03:25:33 GMT

you can try

FIMA_DAYS_AND_MONTHS_AND_YEARS

FIMA_DECIMAL_MONTHS_AND_YEARS

regards

shiba dutta

Re: function for dates

Former Member — Wed, 03 Oct 2007 04:09:45 GMT

good

try these functioin modules

HR_IE_NUM_PRSI_WEEKS Return the number of weeks between two dates.

thanks

mrutyun^

Re: function for dates

Former Member — Wed, 03 Oct 2007 04:14:29 GMT

Hi ,

There is no FM which will return the difference in Months, but days months and year.

Belwo is the FM:

HR_HK_DIFF_BT_2_DATES Days, months and years between two dates

Revert back if any issues,

Reward if helpful.

Regards,

Naveen

Re: function for dates

Former Member — Wed, 03 Oct 2007 04:16:30 GMT

Hi,

please take the help from the code as below :

data : date1 type sy-datum,

date2 type sy-datum.

data : w_day(3),

nw_day(3).

date1 = '20070701'.

date2 = '20070731'.

data : days type VTBBEWE-ATAGE, years type VTBBEWE-ATAGE, months type VTBBEWE-ATAGE.

data : a_new type sy-datum, b_new type sy-datum.

CALL FUNCTION 'FIMA_DAYS_AND_MONTHS_AND_YEARS'

EXPORTING

i_date_from = date1

I_KEY_DAY_FROM = '00'

i_date_to = date2

I_KEY_DAY_TO = '00'

I_FLG_SEPARATE = ' '

IMPORTING

E_DAYS = days

E_MONTHS = months

E_YEARS = years.

Regards,

Sandeep Kaushik

Re: function for dates

varma_narayana — Wed, 03 Oct 2007 04:18:59 GMT

Hi...

Check the following code for subtract years/months/date from particular date:

DATA: EDAYS LIKE VTBBEWE-ATAGE,

EMONTHS LIKE VTBBEWE-ATAGE,

EYEARS LIKE VTBBEWE-ATAGE.

PARAMETERS: FROMDATE LIKE VTBBEWE-DBERVON,

TODATE LIKE VTBBEWE-DBERBIS DEFAULT SY-DATUM.

call function 'FIMA_DAYS_AND_MONTHS_AND_YEARS'

exporting

i_date_from = FROMDATE

i_date_to = TODATE

I_FLG_SEPARATE = ' '

IMPORTING

E_DAYS = EDAYS

E_MONTHS = EMONTHS

E_YEARS = EYEARS.

WRITE:/ 'Difference in Days ', EDAYS.

WRITE:/ 'Difference in Months ', EMONTHS.

WRITE:/ 'Difference in Years ', EYEARS.

INITIALIZATION.

FROMDATE = SY-DATUM - 60.

reward if Helpful.

Re: function for dates

Former Member — Wed, 03 Oct 2007 04:32:24 GMT

HAI TRY THIS

REPORT ZSAN_SDN2.

SELECTION-SCREEN: BEGIN OF BLOCK B1 WITH FRAME.

PARAMETER:

N1 TYPE T,

N2 TYPE T.

DATA: DN1 TYPE T,

DN2 TYPE T,

DN3 TYPE I,

DN4 TYPE I,

DN6 TYPE I,

DN5 TYPE I.

SELECTION-SCREEN:

BEGIN OF LINE,

PUSHBUTTON 2(10) BUT1 USER-COMMAND CALC,

PUSHBUTTON 13(10) BUT2 USER-COMMAND EXIT,

END OF LINE.

SELECTION-SCREEN END OF BLOCK B1.

AT SELECTION-SCREEN.

CASE SY-UCOMM.

WHEN 'CALC'.

MOVE: N1 TO DN1,

N2 TO DN2.

DN3 = DN2 - DN1 .

DN3 = DN3 MOD 86400.

DN4 = DN3 / 3600 .

DN6 = DN3 / 60 .

DN5 = DN6 MOD 60.

DN3 = DN3 MOD 3600 .

DN3 = DN3 MOD 60 .

LEAVE TO LIST-PROCESSING.

SET PF-STATUS SPACE.

WRITE: / DN4, 'hours'.

WRITE: / DN5, 'minutes'.

WRITE: / DN3, 'seconds'.

WHEN 'EXIT'.

LEAVE PROGRAM.

ENDCASE.

INITIALIZATION.

BUT1 = 'calc'.

BUT2 = 'exit'.

Re: function for dates

Former Member — Wed, 03 Oct 2007 04:47:27 GMT

SORRY.. ITS FOR TIME

Re: function for dates

Former Member — Wed, 03 Oct 2007 04:58:42 GMT

hi,

The appropriate finction module is ' HR_SGPBS_YRS_MTHS_DAYS'.

regards

Debjani Lahiri

Rewards point for helpful answer