topic Re: problem in comparison date in Application Development and Automation Discussions

problem in comparison date

Former Member — Tue, 28 Aug 2007 11:39:45 GMT

hallow

i doing loop that check if tmp_begda < v_date1.

1.in the first time tmp_begda = 01012006 and v_date1 = 01012007

and if go to the end if (o.k.)

2.in the second time tmp_begda = 01022006 and v_date1 = 01012007

and i go to the else statment and do modify.

why tmp begda is less then v_date?

tmp_begda and v_date type sy-datum.

i reward

this is my code

loop....

IF tmp_begda < v_date1.

ELSE.

MOVE tmp_begda TO wa_period-date1.

MODIFY period_tbl FROM wa_period TRANSPORTING date1.

ENDIF.

ENDLOOP.

Re: problem in comparison date

Former Member — Tue, 28 Aug 2007 11:41:37 GMT

Hi!

SAP handles date in the following internal format: YYYYMMDD

If you are filling dynamically those fields, try using this format.

Regards

Tamá

Re: problem in comparison date

Former Member — Tue, 28 Aug 2007 11:45:59 GMT

when you are comparing the dates should be of type sy-datum and should be in the format YYYYMMDD,

chk these 2 programs

REPORT ZTEST.

DATA : V_DATE1 LIKE SY-DATUM,
       V_DATE2 LIKE SY-DATUM..

V_DATE1 = '01022006'.
V_DATE2 = '01012007'.

IF V_DATE1 LE V_DATE2.
  WRITE : 'yes'.
ELSE.
  WRITE : 'no'.
ENDIF.

Output : No.

REPORT ZTEST.

DATA : V_DATE1 LIKE SY-DATUM,
       V_DATE2 LIKE SY-DATUM..

V_DATE1 = '20060201'.
V_DATE2 = '20070101'.

IF V_DATE1 LE V_DATE2.
  WRITE : 'yes'.
ELSE.
  WRITE : 'no'.
ENDIF.

Output : Yes

Re: problem in comparison date

Former Member — Tue, 28 Aug 2007 11:47:32 GMT

Hi Tal,

If you pass any value to the variable to date field then it should be in the format YYYYMMDD and it will stored in the internal format as MMYYDDDD.

Check whether you are passing value to V_DATE1 as YYYYMMDD??

Thanks,

Vinay