topic Re: date problem. in Application Development and Automation Discussions

date problem.

Former Member — Tue, 10 Jun 2008 09:19:15 GMT

in table dates is save as 20080602 that is 2 june, 08

so how can we recognize it in a program if we had defined the variable as dats type.......if we assign it in that variable then it wil take this date as 02.06.2008 ....so as both the pattern are sumwhat different so it is not fetching data from table...

plz comment what to do in this case

Re: date problem.

Former Member — Tue, 10 Jun 2008 09:25:38 GMT

HI,

Declare char(8) type c variable.

Since you know the format in which it is stored.. get the values

l_day = l_date+6(2).

l_month = l_date+4(2).

l_year = l_date+0(4).

Then concatenate above values as per your requirement.

Best regards,

Prashant

Re: date problem.

Former Member — Tue, 10 Jun 2008 09:25:42 GMT

Hi,

use Write statment, which will will convert to system format

suppose date is stored in vaiable w_Date as 6 may 2007

write w_date to w_date1

now the value of w_date1 will be in system date format.

Regards,

Sriram

Re: date problem.

Former Member — Tue, 10 Jun 2008 09:26:29 GMT

There are two ways.

1. You can modify the table (I guess its a Z table)

2. Use CONVERT_DATE_TO_INTERNAL to get the internal date format.Pass this to a varibla of CHAR8 and use this value in the selection parameter.

Re: date problem.

Former Member — Tue, 10 Jun 2008 09:39:40 GMT

Hi,

1.just convert the input date as sy-date and then select the values.

Like:

and also Replace keyword ,u can convert the 02.06.2008 into 02062008.Then use the logic of offset.

Regards,

Shiva Kumar

Re: date problem.

Former Member — Tue, 10 Jun 2008 09:41:29 GMT

thanks