topic Re: date declaration query in Application Development and Automation Discussions

date declaration query

Former Member — Thu, 15 Jun 2006 13:34:05 GMT

Hi ,

can any one tell me how to declare field for date . i have an excel sheet in which the date is like this

06/15/2006

when i declared internal table like

erdat like sy-datum its taking 6/15/200

can any body tell how to get the enite thing please let me know.

Thanks in advance.

Re: date declaration query

Former Member — Thu, 15 Jun 2006 13:37:47 GMT

Hai Swathi

declare like this

sy-datum '20060615'.

Thanks & regards

Sreeni

Re: date declaration query

Former Member — Thu, 15 Jun 2006 13:37:54 GMT

swathi,

Declare

data erdat(10) type c.

it will take 06/15/2006.

rgds,

TM.

Re: date declaration query

Former Member — Thu, 15 Jun 2006 13:38:02 GMT

Then Swathi, you have to convert the date in the excel sheet to yyyymmdd format and then pass it to the sy-datum like variable.

Re: date declaration query

Former Member — Thu, 15 Jun 2006 13:38:16 GMT

declare it as char

data : erdat(10).

Re: date declaration query

Former Member — Thu, 15 Jun 2006 13:40:21 GMT

Yes, thats because sy-datum is of type DATS having length 8. You need to declare a character field of length 10, upload your data and then move it to a date field.

Internally the date field will store the date as yyyymmdd so you can do something like this:

concatenate c16(4) c10(2) c1+3(2) into date. (where c1 is the char field)

Regards

Shounak

Re: date declaration query

Former Member — Thu, 15 Jun 2006 13:53:02 GMT

Hi Swathi,

Date declaration should be done as:

Ex:

date TYPE d VALUE '19980601'.

Regards.

Laxmi

Re: date declaration query

Former Member — Thu, 15 Jun 2006 13:54:40 GMT

Thanks guys.

I got the problem solved by declaring like

data : erdat(10) type c.

Thanks each and everyone for your valuable inputs.

Re: date declaration query

Former Member — Thu, 15 Jun 2006 13:56:43 GMT

Hi,

in your flat file change your date format <b>20060615</b>

in your internal table try to declare the erdate as

like this

data : begin of itab occurs 0,
        ....
<b>       erdat(10),</b>
      end of itab.

Regards

vijay