topic Re: Date field issue in Application Development and Automation Discussions

Date field issue

Former Member — Wed, 12 Nov 2008 10:19:39 GMT

Hi All,

If Iam having a date, say 28/02/2008. I wan to add '1' to this date.

DATE1 = '20080228'.

DATE2 = DATE1 + 1.

Now DATE2 will gimme '20080229'. But I should get 2008/03/01.

Is it possible ot get the same.

Regards,

Viji

Re: Date field issue

Former Member — Wed, 12 Nov 2008 10:21:15 GMT

Hi,

Use this Function module

CONVERSION_EXIT_PDATE_OUTPUT Conversion Exit for Domain GBDAT: YYYYMMDD -> DD/MM/YYYY

Regards

Manasa

Re: Date field issue

Former Member — Wed, 12 Nov 2008 10:24:42 GMT

Hi Manasa,

I think 'CONVERSION_EXIT_PDATE_OUTPUT' will not help for this.

Regards,

Viji.

Re: Date field issue

Former Member — Wed, 12 Nov 2008 10:27:56 GMT

Hi,

It is the correct result. Year 2008 is a Leap year and has 29 days. IF you change the year to 2007 or 2009, it will give you 1st March.

If you want 2008 add 2 to the date 20080228 , you will get what you want.

regards,

Advait

Re: Date field issue

Former Member — Wed, 12 Nov 2008 10:29:49 GMT

This code works.


DATA: l_date TYPE sy-datum.

l_date = sy-datum.

l_date = l_date + 1.

WRITE l_date.

Regards

Sam

Re: Date field issue

Former Member — Wed, 12 Nov 2008 10:30:22 GMT

REPORT ZSRK_045 .

DATA : V_DATE LIKE SY-DATUM.

DATA : DATE LIKE SY-DATUM.

DATE = '20080228'.

CALL FUNCTION 'RP_CALC_DATE_IN_INTERVAL'

EXPORTING

DATE = DATE

DAYS = 1

MONTHS = 0

SIGNUM = '+'

YEARS = 0

IMPORTING

CALC_DATE = V_DATE.

WRITE : / V_DATE.

Re: Date field issue

Former Member — Wed, 12 Nov 2008 10:30:57 GMT

hii,

we have 29 days in feb this year.

with regards,

sandeep akella.

Re: Date field issue

Former Member — Wed, 12 Nov 2008 10:31:42 GMT

hi,

2008 is a leap year

try the same with date 20070228

you will get the desired result.

Regards,

Prakash Pandey

Re: Date field issue

Former Member — Wed, 12 Nov 2008 10:31:52 GMT

Hi, I got the solution for this.

THANKS ALOT.

Re: Date field issue

Former Member — Wed, 12 Nov 2008 10:32:33 GMT

HI,

try this Fm

BKK_ADD_WORKINGDAY

Re: Date field issue

Former Member — Wed, 12 Nov 2008 10:33:31 GMT

Hi,

The ouput you are getting is correct. 2008 is a leap year.

Thanks.