topic Re: compare 2 date fields in Application Development and Automation Discussions

compare 2 date fields

Former Member — Sat, 04 Oct 2008 11:16:09 GMT

hi all,

I want to compare 2 date fields in from internal table using loop how is this possible . I tried lot.

Plz help me.

Re: compare 2 date fields

piyush_mathur — Sat, 04 Oct 2008 11:17:48 GMT

Hi,

If both are date fields then u can compare using relational operation.

Thanks

Piyush

Re: compare 2 date fields

Former Member — Sat, 04 Oct 2008 11:18:51 GMT

Hi piyush ,

If i m using '> ' condition then it gives wrong answer.

Plz help me..

Re: compare 2 date fields

former_member125931 — Sat, 04 Oct 2008 11:19:48 GMT

suppose u have two internal tables ITAB1,ITAB2 and work areas WA!,WA2 respectively,suppose MATNR is the field u want to compare for ur condition.

if WA1-MATNR = WA2-MATNR .

write:/sy-subrc.

endif.

If you send your coding we will give u the exact solution.

Re: compare 2 date fields

Former Member — Sat, 04 Oct 2008 11:23:18 GMT

SELECT BELNR BUDAT GJAHR BLDAT

INTO (ITAB-BELNR,ITAB-BUDAT,ITAB-GJAHR,ITAB-BLDAT)

FROM BKPF

WHERE BLDAT <= BUDAT

AND BUKRS = 'ABCB'

AND BLART = 'RV'.

SELECT KUNNR SHKZG WRBTR ZFBDT BSCHL VBELN AUGBL ZBD1T ZTERM AUGDT

BELNR

INTO (ITAB-KUNNR,ITAB-SHKZG,ITAB-WRBTR,ITAB-ZFBDT,ITAB-BSCHL,

ITAB-VBELN,ITAB-AUGBL,ITAB-ZBD1T,ITAB-ZTERM,ITAB-AUGDT,ITAB-BELNR1)

FROM BSEG

WHERE BELNR = ITAB-BELNR

AND BUKRS = 'ABCB'

AND KUNNR IN KUNNR

AND KOART = 'D'

AND GJAHR = ITAB-GJAHR.

APPEND ITAB.

ENDSELECT.

LOOP AT ITAB.

ITAB-NET_DUE_DT = ITAB-ZBD1T + ITAB-ZFBDT.

MODIFY ITAB.

ENDLOOP.

in this coding i want to compare

ITAB-NET_DUE-DT < = ITAB-AUGDT.

PLZ. HELP ME.

Re: compare 2 date fields

Former Member — Sat, 04 Oct 2008 11:39:03 GMT

hi sree,

Did u got any solution for it.

Plz help me...

Re: compare 2 date fields

piyush_mathur — Sat, 04 Oct 2008 11:49:51 GMT

Please let us know in what dates your conditions are failing.

Below code is working fine for me.

DAT1 = '20071231'.

DAT2 = '20070131'.

IF DAT1 <= DAT2.

BREAK-POINT.

ENDIF.

Piyush

Re: compare 2 date fields

former_member125931 — Sat, 04 Oct 2008 11:50:20 GMT

Hi,

ITAB-NET_DUE-DT < = ITAB-AUGDT.

First check Is your ITAB having working OR not,otherwise declare work area explicitely.

Re: compare 2 date fields

Former Member — Sat, 04 Oct 2008 11:51:05 GMT

what do u want to check?

if u want to compare dates?

wa_date1(2) > wa_date2(2).

date1 = 28102002

this will compare the first two numbers of ur work area..i.e first two numbers are 28..28 is the date.

Re: compare 2 date fields

former_member125931 — Sat, 04 Oct 2008 11:55:01 GMT

I think it is ITAB-NET_DUE_DT < = ITAB-AUGDT not ITAB-NET_DUE-DT < = ITAB-AUGDT.

Re: compare 2 date fields

Former Member — Sat, 04 Oct 2008 11:56:21 GMT

anil..

its date like '20040111'.

both date are in same formate.

Plz help me...

Re: compare 2 date fields

piyush_mathur — Sat, 04 Oct 2008 11:57:31 GMT

What are the dates, in which ur condition is fails.

Give one example.

Re: compare 2 date fields

Former Member — Sat, 04 Oct 2008 12:00:58 GMT

hi..

if i m using such condition then

1 date compares with another dates of second column.

i want to compare 1 date with only 1 date of another column.

Re: compare 2 date fields

Former Member — Sat, 04 Oct 2008 12:28:55 GMT

then u can write

write loop it into wa...endloop.

inside loop -

endloop

wa1_date6(2) > wa2_date6(2).

then u can compare dates.

Re: compare 2 date fields

former_member125931 — Sat, 04 Oct 2008 12:40:32 GMT

HI Ankita,

Did u solved u problem otherwise give me ur total code I'll try to help u

Re: compare 2 date fields

Former Member — Sat, 04 Oct 2008 12:54:20 GMT

> SELECT BELNR BUDAT GJAHR BLDAT

> INTO (ITAB-BELNR,ITAB-BUDAT,ITAB-GJAHR,ITAB-BLDAT)

> FROM BKPF

> WHERE BLDAT <= ITAB-BUDAT

> AND BUKRS = 'ABCB'

> AND BLART = 'RV'.

Use ITAB-BUDAT in where condittion, as shown above.