topic Re: Date manipulation in Application Development and Automation Discussions

Date manipulation

Former Member — Mon, 17 Mar 2008 06:04:33 GMT

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.

Re: Date manipulation

Former Member — Mon, 17 Mar 2008 06:09:49 GMT

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.

Re: Date manipulation

Former Member — Mon, 17 Mar 2008 06:11:12 GMT

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.

Re: Date manipulation

Former Member — Mon, 17 Mar 2008 06:47:02 GMT

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.