topic Re: About Dates in Application Development and Automation Discussions

About Dates

Former Member — Thu, 14 Sep 2006 10:36:28 GMT

Hi Everyone ,

I have to pass the Date and have to get the End of month

Ex : if I pass 09142006 as inputdate I need 09302006

as my Output date .

Is there any Function Module available or

what is the way to proceed ..

Thanks in Advance,

Regards,

PAVAn.

Re: About Dates

Former Member — Thu, 14 Sep 2006 10:38:33 GMT

CHECK.

RP_LAST_DAY_OF_MONTHS

Re: About Dates

Former Member — Thu, 14 Sep 2006 10:40:04 GMT

Use the FM <b>RE_LAST_DAY_OF_MONTH</b>

Re: About Dates

Former Member — Thu, 14 Sep 2006 10:41:02 GMT

u can use the simple logic...

ldate <= inputdate of type date.

lmon = ldate+4(2) + 1.

concatenate ldate(4) lmon '01' into ldm.

ldm = ldm - 1.

Re: About Dates

Former Member — Thu, 14 Sep 2006 10:44:36 GMT

REPORT  Z_TEST.

DATA : DATE1 LIKE SY-DATUM,
       LAST LIKE SY-DATUM.

CALL FUNCTION 'SG_PS_GET_LAST_DAY_OF_MONTH'
  EXPORTING
    DAY_IN            = SY-DATUM
  IMPORTING
    LAST_DAY_OF_MONTH = LAST.

WRITE : / LAST.

Re: About Dates

Former Member — Thu, 14 Sep 2006 10:44:47 GMT

From that FM my Enddate will be in 09/30/2006

I want to get 09302006.

Re: About Dates

Former Member — Thu, 14 Sep 2006 10:49:25 GMT

Lets day ldate is the output of the FM..after that use the below and it get you the date in required format.

Translate ldate using '/ '.

Condense ldate no-gaps.

Write ldate to lfdate MMDDYYYY.

Message was edited by: Anurag Bankley

Re: About Dates

Former Member — Thu, 14 Sep 2006 10:50:53 GMT

then go like this

REPORT  Z_TEST.

DATA : DATE1(10),
       LAST LIKE SY-DATUM.

CALL FUNCTION 'SG_PS_GET_LAST_DAY_OF_MONTH'
  EXPORTING
    DAY_IN            = SY-DATUM
  IMPORTING
    LAST_DAY_OF_MONTH = LAST.

WRITE : LAST to date1 MM/DD/YYYY.

REPLACE all occurrences of '/' IN date1 WITH SPACE.

CONDENSE date1.

WRITE : / date1.

Reward if helpful and close thread if solved

Message was edited by: Chandrasekhar Jagarlamudi

Re: About Dates

Former Member — Thu, 14 Sep 2006 11:11:26 GMT

hi pavan,

use the function module RP_LAST_DAY_OF_MONTHS.

that should help u

regards,

sudha.