Date manipulation

[Former Member]

Hi all,

if i'm assigning two date fields to a particular variable like V_DATE3 and V_DATE1,will the following statement written below will work...for me its not working..can anyone suggest a method for this???

SELECT SINGLE BEGDA ENDDA FROM PA0000 INTO (V_DATE1,V_DATE3) WHERE PERNR = P_PERNR

V_DATE2 = V_DATE2 - 1.

Merlin.

[Former Member]

Hi,

see this code.

its working fine for me.

only u forgot the full stop(.)

DATA:v_date1 type sy-datum,
      v_date2 TYPE sy-datum,
      v_date3 TYPE sy-datum.
PARAMETERS:p_pernr TYPE pa0000-pernr.
SELECT SINGLE BEGDA ENDDA FROM PA0000 INTO (V_DATE1,V_DATE3) WHERE PERNR = P_PERNR.

V_DATE2 = V_DATE2 - 1.

rgds,

bharat.

[Former Member]

Data: v_date1 type sy-datum,
        v_date2 type sy-datum.
 

SELECT SINGLE BEGDA ENDDA FROM PA0000 INTO (V_DATE1,V_DATE3) WHERE PERNR = P_PERNR 

V_date2 = V_date1 - 1.

[Former Member]

Hi,

You have to give the TYPE of V_DATE1 and V_DATE2 as SY-DATUM.

data : v_date1 type sy-datum,

v_date2 type sy-datum.