topic Date Conversions in Application Development and Automation Discussions

Date Conversions

Former Member — Tue, 14 Oct 2008 03:50:39 GMT

Dear All,

I have some problem in solving the date issues can anyone try to solve this problem,

Actually my input is 20.08.1013.,., i need output in the format of 13.10.2008.. Is there any function module

to convert this..,

Thanks,

Thirukumaran. R

Re: Date Conversions

bpawanchand — Tue, 14 Oct 2008 03:53:16 GMT

IT is in the format of YYYYMMDD use OFFSET concept and concatenate the offset value to a string and after that pass it to a variable of type SY-DATUM your problem is solved.

example

DATA :

w_d1 TYPE sy-datum,

w_str TYPE string.

w_d2 TYPE sy-datum VALUE '20.08.1013'.

CONCATENATE w_d20(2) w_d23(2) w_d2+6(4) INTO w_str.

now in w_str the value will be '20081013'.

now assign

w_d1 = w_str .

Regards

Pavan

Re: Date Conversions

Former Member — Tue, 14 Oct 2008 03:55:24 GMT

Try out the below mentioned Funciton Module


CONVERT_DATE_TO_INTERNAL

Thanks,

Chidanand

Re: Date Conversions

Former Member — Tue, 14 Oct 2008 04:11:13 GMT

This message was moderated.

Re: Date Conversions

Former Member — Tue, 14 Oct 2008 04:23:03 GMT

Hi.

This code may help u.....


PARAMETERS: p TYPE sy-datum DEFAULT sy-datum.
DATA: d TYPE char10 .

WRITE p TO d MM/DD/YYYY.

Re: Date Conversions

Former Member — Tue, 14 Oct 2008 04:32:55 GMT

Hi thiru,

When ever you want to print the date the format specified just use the following

Data : a type Sy-datum.

Write:a MM/DD/YYYY.

or Write: DD/MM/YYYY.

or write: YYYY/DD/MM.

Use the above write statement according to your convience.

Cheers!!

Re: Date Conversions

Former Member — Tue, 14 Oct 2008 04:34:27 GMT

When i execute the following code the output is '13.10.2081'. date and month are right i need year as 2008.,

Recode my codings.,

constants: date type dats value '20081013'.

data : w_d1 TYPE sy-datum,

w_str TYPE string,

w_d2 TYPE sy-datum VALUE date.

CONCATENATE w_d20(2) w_d23(2) w_d2+4(4) INTO w_str.

w_d1 = w_str .

write : / w_d1.

Thanks,

ThiruKumaran. R

Re: Date Conversions

bpawanchand — Tue, 14 Oct 2008 04:39:06 GMT

constants: date type dats value '20081013'.
data : w_d1 TYPE sy-datum,
w_str TYPE string,
w_d2 TYPE sy-datum VALUE date.
CONCATENATE w_d2+0(2) w_d2+3(2) w_d2+4(4) INTO w_str.
w_d1 = w_str .
write : / w_d1.

CONCATENATE w_d26(2) w_d24(2) w_d2+0(4) INTO w_str.

Now in w_str you will have date as '13102008'.

Regards

Pavan

Re: Date Conversions

Former Member — Tue, 14 Oct 2008 04:49:20 GMT

Sorry,

my codings is like this,

constants: date type dats value '20.08.1013'.

data : w_d1 TYPE sy-datum,

w_str TYPE string,

w_d2 TYPE sy-datum VALUE date.

CONCATENATE w_d20(2) w_d23(2) w_d2+4(4) INTO w_str.

w_d1 = w_str .

write : / w_d1

Then how to post the message in your format .,.,

Thanks,

Thiru.

Edited by: thirukumaran rajendran on Oct 14, 2008 6:49 AM