topic Date format in Application Development and Automation Discussions

Date format

Former Member — Wed, 06 Feb 2008 20:29:12 GMT

Hi Experts,

I have a variable 'var_date1' in which I am passing the current date , and sending the same to a file.

data : begin of itab occurs 0,

var_date1 type sy-datum,

end of itab.

itab-var_date1 = sy-datum.

append itab.

clear itab.

itab-var_date1 = sy-datum - 1.

append itab.

clear itab.

My question is I want the date in internal table in the format MM/DD/YYYY.How to achieve this.What is the synax.

Regards,

Vishnu.

Edited by: Alvaro Tejada Galindo on Feb 6, 2008 4:03 PM

Re: Date format

former_member156446 — Wed, 06 Feb 2008 20:33:42 GMT

data : date(10),

date = sy-datum.

year = sy-datum(4).
month = sy-datum+4(2).
day = sy-datum+6(2).

concatenate month day year into lv_date seperated by '/'.
condense lv_date.

Re: Date format

Former Member — Wed, 06 Feb 2008 20:38:02 GMT

Your date variables are all of type sy-datum which is 8 bytes. You cannot squeeze 10 bytes into an 8 byte field.

Rob

Re: Date format

Former Member — Wed, 06 Feb 2008 20:38:56 GMT

Hi Jay,

Is there any direct way to do this instead of hard coding.( Like edit mask or something?

Vishnu

Re: Date format

Former Member — Wed, 06 Feb 2008 20:39:37 GMT

Ur input is DD.MM.YYYY.format .Then check this..

Ex.

DATA: V_INPUT(10) VALUE '06.02.2008'.

DATA: V_OUTPUT(10).

CONCATENATE V_INPUT3(2) '/' V_INPUT(2) '/' V_INPUT6(4)

INTO V_OUTPUT.

WRITE: / V_OUTPUT.

Re: Date format

Former Member — Wed, 06 Feb 2008 20:41:37 GMT

Check this thread ..using edit mask

Re: Date format

Former Member — Wed, 06 Feb 2008 20:46:22 GMT

Hi Vishnu,

data : v_date(10).

write sy-datum to v_date dd/mm/yyyy.

add your required date format,

like dd/mm/yyyy or mm/dd/yyyy or any other.

Regards,

Ali

Re: Date format

former_member156446 — Wed, 06 Feb 2008 21:56:03 GMT

edit mask wont work for ur requirement..

check the documentation F1 of mask.... it might help you.. for future..

Re: Date format

Former Member — Thu, 07 Feb 2008 04:00:41 GMT

Hi,

Use like:

DATA : BEGIN OF itab OCCURS 0,

var_date1 TYPE dats,

END OF itab.

itab-var_date1 = sy-datum.

APPEND itab.

CLEAR itab.

itab-var_date1 = sy-datum - 1.

APPEND itab.

CLEAR itab.

LOOP AT itab.

WRITE:/ itab-var_date16(2), ' / ' , itab-var_date14(2), ' / ' , itab-var_date1+0(4) .

ENDLOOP.

Regards,

Renjith Michael.