topic Re: date format changes in Application Development and Automation Discussions

date format changes

Former Member — Wed, 31 Oct 2007 10:13:33 GMT

Hi,

There is one date field , to that field recently time is also added.

Previously when iam fetching the data on that time based up on sy-datum iam fetching data i.e.

Select * from zghar_tab into

table GI_ghar where zapp_date = sy-datum.

Now the problem is for 'zapp_date ' this field 'HHMMSS' are added.

Now the field length is 14 in the format of 'YYYYMMDDHHMMSS'.

Now what changes i have to do from my side here for this format adding.

Please help.

Thanks

Ali

Re: date format changes

Former Member — Wed, 31 Oct 2007 10:16:03 GMT

Hi,

Use offset upto 8 chars in the date while retriving the data.

Satish

Re: date format changes

Former Member — Wed, 31 Oct 2007 10:17:30 GMT

take a char variable

data : dat(9).

concatenate sy-datum '%' into dat

Select * from zghar_tab into

table GI_ghar where zapp_date like dat.

regards

shiba dutta

Re: date format changes

Former Member — Wed, 31 Oct 2007 10:19:51 GMT

Try using this function module 'CACS_DATE_GET_TIMESTAMP' for adding timestamp to ur 'zapp_date'

Thanks

Vasudha

Re: date format changes

Former Member — Wed, 31 Oct 2007 10:20:31 GMT

hi ALI,

just in the select query write :

Select * from zghar_tab into

table GI_ghar

where zapp_date(8) = sy-datum

Re: date format changes

Former Member — Wed, 31 Oct 2007 10:21:26 GMT

Please send me that in example

Re: date format changes

Former Member — Wed, 31 Oct 2007 10:22:30 GMT

in program flow the date in sy-datum is of type yyyyddmm

20071031

reward and close thread if answered

thank you,

taher

Re: date format changes

Former Member — Wed, 31 Oct 2007 10:23:14 GMT

Try this...

data:

w_date type zapp_date. "(CHAR14)

w_date = sy-datum.

concatenate w_date

'%'

into w_date.

Select * from zghar_tab into

table GI_ghar where zapp_date LIKE w_date.

Now the problem is for 'zapp_date ' this field 'HHMMSS'

Re: date format changes

Former Member — Wed, 31 Oct 2007 10:24:18 GMT

I wrote like this but error message is coming.

Error'Field is unknown' like this

Please check this and help me

Re: date format changes

andreas_mann3 — Wed, 31 Oct 2007 10:24:21 GMT

look commands in abap-help:

   CONVERT TIME STAMP wa-timestamp
              TIME ZONE tzone
              INTO DATE bdate TIME btime.

Re: date format changes

Former Member — Wed, 31 Oct 2007 10:31:27 GMT

Why you wrote like this what is the problem with that field.

Plese tell me

Re: date format changes

Former Member — Wed, 31 Oct 2007 10:33:00 GMT

hi ,

i have just checked .

we cannot do the way i suggested as offwset cannot be put in the where clause

Re: date format changes

Former Member — Wed, 31 Oct 2007 10:52:18 GMT

hi ahammad,

try it.

Select * from zghar_tab into

table GI_ghar where zapp_date+0(8) = sy-datum.

Regards

Allan Cristian

Re: date format changes

Former Member — Wed, 31 Oct 2007 12:02:03 GMT

hi ahammad,

try it plx,

maybe can help u solver ur problem...

select * from ZGHAR_TAB into table GI_ghar.

loop at GI_ghar.

if GI_ghar-ZAPP_DATE(8) <> sy-datum.

DELETE GI_ghar INDEX sy-tabix.

endif.

endloop.

plx, post urs results here...

Regards

Allan Cristian