topic Re: Date conversion in Application Development and Automation Discussions

Date conversion

Former Member — Tue, 30 Aug 2005 15:57:23 GMT

Hi,

I have the date 20050703 , in the format YYYYMMDD,

and I need the most efficient way of converting it into the format DD.MM.YYYY , so the above date would be

03.07.2005

What is the best way of doing this?

thanks!!

Re: Date conversion

Former Member — Tue, 30 Aug 2005 16:06:05 GMT

Where do you want to do it?

If in an abap list:

WRITE SY-DATUM DD/MM/YYYY.

Re: Date conversion

RichHeilman — Tue, 30 Aug 2005 16:07:03 GMT

Here is a quick way.



report zrich_0002 .


data: datum(10) type c.


concatenate sy-datum+6(2) '.' sy-datum+4(2) '.' sy-datum+0(4)
                into datum.

write:/ datum.

Regards,

Rich Heilman

Re: Date conversion

Former Member — Tue, 30 Aug 2005 16:08:19 GMT

Hi,

I want to put it into a variable: as in the code below

bdcdtab-dynpro = '0000'.

bdcdtab-dynbegin = ' '.

bdcdtab-fnam = 'BKPF-BUDAT'.

bdcdtab-fval = '12.07.2005'. " ybsid-budat CPosting Date in the

and I have the date in ybsid-budat

Re: Date conversion

Former Member — Tue, 30 Aug 2005 16:09:25 GMT

WRITE ybsid-budat USING EDIT MASK '__.__.____' to bdctab-fval.

Re: Date conversion

Former Member — Tue, 30 Aug 2005 16:13:16 GMT

I think the better and easier way is to write data in format DDMMYY, and so:

WRITE MY_DATE DDMMYY TO bdcdtab-fval.

This format is ok for B.I.

Re: Date conversion

Former Member — Tue, 30 Aug 2005 16:14:40 GMT

Thanks Rich - thats done it!!

Re: Date conversion

RichHeilman — Tue, 30 Aug 2005 16:18:54 GMT

Please make sure to award points for helpful answers. Thanks.

Regards,

Rich Heilman

Re: Date conversion

Former Member — Tue, 30 Aug 2005 16:22:01 GMT

Max,

Shouldn't this be just -

write my_date (or ybsid-budat) to bdcdtab-fval.

Sims,

This is the correct way to format date, this will format date according to the user's date format(as per user profile). You shouldn't hardcode the date format, when you can easily write more generic logic.

Cheers,

Sanjeev

Re: Date conversion

Former Member — Tue, 30 Aug 2005 16:37:01 GMT

I didn't write

write my_date (or ybsid-budat) to bdcdtab-fval.

but

write my_date (or ybsid-budat) DDMMYY to bdcdtab-fval.

So if my_date is 20050830, bdcdtab-fval is 300805.

This format is always ok for whichever B.I. of FI, infact, for example, if you use B.I. standard (RFBIBL00) all date fields are long 8 char, so you can't write date in the format that Sims want to use (30.08.2005).

Moreover this format is not depend on user's date format, so I can always be sure that my B.I. is ok for all users.

I'm agree with you, the statament WRITE has many options to format a date and it's better to use them than to process it by concatenate

Message was edited by: max bianchi

Re: Date conversion

Former Member — Tue, 30 Aug 2005 19:10:39 GMT

Please close the post once resolved so that others wont try to answer it anymore.

Thanks,

Srinivas

Re: Date conversion

Former Member — Wed, 31 Aug 2005 03:25:48 GMT

Hi,

Date formatting   

The following code demonstrates a number
 of ways to format a date value:
 
* Using the WRITE statement
***************************
  data: gd_date(10).  
      "field to store output date

* Converts date from 20020901 to 01.09.2002
  write sy-datum to gd_date dd/mm/yyyy.
* Converts date from 20020901 to 01.09.02
  write sy-datum to gd_date dd/mm/yy.


 

 

* Using data manipulation techniques
************************************
  data: gd_date(8). 
     "field to store output date

* Converts date from 20010901 to 01092001
  gd_date(2)   = sy-datum+6(2).
  gd_date+2(2) = sy-datum+4(2).
  gd_date+4(4) = sy-datum(4).


 

 

* Using Function modules
************************
  data: gd_date(8).
       "field to store output date

* Converts date from 20010901 to 01SEP2001
  gd_date   = sy-datum.
  CALL FUNCTION 'CONVERSION_EXIT_IDATE_OUTPUT'
    EXPORTING
      input         = gd_date
    IMPORTING
      OUTPUT        = gd_date.

Refer this link

http://www.sapdevelopment.co.uk/tips/date/date_format.htm

Kindly reward points and close the thread.

Re: Date conversion

Former Member — Wed, 31 Aug 2005 03:31:14 GMT

Hi Sims,

If you don't close the thread, people are still thinking that it is not solved for you and trying to help you. Since you mentioned, Rich's solution solved your problem, please close the thread so that others wont try to answer this.

Thanks,

Srinivas