topic Re: Date function in Application Development and Automation Discussions

Date function

Former Member — Fri, 30 Sep 2005 05:40:59 GMT

Dear All

Please let me the function modules for the following

1. calculate the no. of day between two dates.

2. derive the last day of a month.

3. geting a new date by adding or substracting no of days to a date.

4. extract day, month, year from the date field.

thanks

ravi

Re: Date function

Former Member — Fri, 30 Sep 2005 05:49:52 GMT

hi,

try with this FMs

HR_SEN_CALE_DAYS_DATE ( for 1 & 3)

LAST_DAY_OF_MONTHS (2)

Re: Date function

Former Member — Fri, 30 Sep 2005 05:57:38 GMT

Hi,

Please find those below

1. calculate the no. of day between two dates.

DAYS_BETWEEN_TWO_DATES

2. derive the last day of a month.

RP_LAST_DAY_OF_MONTHS

3. geting a new date by adding or substracting no of

days to a date.

MONTH_PLUS_DETERMINE

Note: For subtracting give -ve value for

MONTHS parameter .

4. extract day, month, year from the date field.

Data :w_date like sy-datum,

w_year(4) type c,

w_day(2) type c,

w_mon(2) type c.

w_date = sy-datum.

w_year = w_date+0(4).

w_mon = w_date+4(2).

w_day = w_date+6(2).

The above holds respective values.

Please reward points if this explanation useful.

Regards,

Siva

Re: Date function

Former Member — Fri, 30 Sep 2005 05:58:10 GMT

Hi Ravi,

Here are some FMs:

> 2. derive the last day of a month. NUMBER_OF_DAYS_PER_MONTH_GET

> 4. extract day, month, year from the date field.

You can do this as follows:

If the date (p_date) is 20050905,

p_year = p_date+0(4).

p_month = p_date+4(2).

p_day = p_date+6(2).

Sudha

Re: Date function

Former Member — Fri, 30 Sep 2005 06:01:33 GMT

thanks all of you for quick anwser.

Re: Date function

Former Member — Fri, 30 Sep 2005 06:38:48 GMT

Dear Siva

What all parameters to be passed to DAYS_BETWEEN_TWO_DAYS function module to get the no. of days between the two days.

Please advice

ravi