Date to String (with increment) problem.

Question

Why does the following code:

  DATA: l_str TYPE string,
        l_dat TYPE d.

  l_dat = sy-datum.
  l_str = l_dat.
  WRITE:/ l_str.

  l_dat = ( sy-datum + 1 ).
  l_str = l_dat.
  WRITE:/ l_str.

  l_dat = sy-datum.
  l_dat = ( l_dat + 1 ).
  l_str = l_dat.
  WRITE:/ l_str.

  l_dat = sy-datum.
  l_str = ( l_dat + 1 ).
  WRITE:/ l_str.

Result in the output (specifically the last line):

And what is the best way to do this instead so as always to get the expected values?

Accepted Answer

4

To understand how this works you probably should check conversion rules for elementary data types. When you add value to variable l_dat it's converted to the number of days since 01.01.0001. In first and 2nd example number is converted back to datum type while you use assignment operator.

Try to use MF 'FORMAT DATE 4 OUTPUT'.

permanent link

answered 09 Feb '13, 08:08

Pawel Hixohe...
211●2●5●11
accept rate: 16%

1

Yup, I also figured this. Just a minor correction. The date is since 01.01.0000... with SAP seeing 01.01.0000 and 00.00.0000 as interchangeably meaning Error (both are equivalent to integer 0).

(09 Feb '13, 13:53) Marius Pieda...

According to http://help.sap.com/saphelp_46c/helpdata/en/fc/eb3434358411d1829f0000e829fbfe/content.htm it's from 01.01.0001.

(09 Feb '13, 15:46) Pawel Hixohe...

yes, the date is specified as from that date as being valid. However, the integer -> date conversion seems to be zero offset on 01.01.0000 thus adding one gives you the first 'valid' date of 01.01.0001

(31 May '13, 08:30) Marius Pieda...

Date to String (with increment) problem.

Follow this question

Related questions