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

Date field manipulation

Former Member — Fri, 20 Jun 2008 16:06:05 GMT

Hi All,

DATA : D1 type D.

D1 = v_date.

v_date contains current date. but when it go to D1 it shows wrong date format. it is taking 8 characters only. i want to send total date like 12/12/2008..but it is showing 12/12/20.Why

Thanks,

Subbu.

Re: Date field manipulation

former_member582701 — Fri, 20 Jun 2008 16:14:40 GMT

Type Date has a long of 8 chars and your variable seems that contain th output format.

When u are doing D1 = v_date u are copying only the first 8 bytes.

In order to fix u can concatenate:

CONCATENATE v_date(2) v_date3(2) v_date7(4) INTO D1.

regards.

Re: Date field manipulation

Former Member — Fri, 20 Jun 2008 16:18:50 GMT

is there any way to pass total date string into variable.

Re: Date field manipulation

former_member582701 — Fri, 20 Jun 2008 16:23:35 GMT

u can try using CONVERT_DATE_TO_INTERNAL

Althought i have seen always the ouput type format for dates like this 12.06.2008 instead of 12/06/2008 but u can try with this FM.

If it does not work i think that u will have to use concatenate statement.

Regards

Re: Date field manipulation

Former Member — Fri, 20 Jun 2008 16:39:52 GMT

This function module converting ddmmyyyy format.

i want dd/mm/yyyy format.

Re: Date field manipulation

Former Member — Fri, 20 Jun 2008 17:01:23 GMT



data: l_date(10) type c.

write sy-datum to l_date.

write l_date.