date comparision in select.

[Former Member]

I want to check date comparision using select query

DATA : IMPODAY TYPE SY-DATUM.

IMPODAY ='20050117'.

SELECT * FROM ZMW0001 INTO TABLE SDYN_ITAB WHERE IMPORTDAY = IMPODAY.

I have declared importday as DATS type in table.

how to compare.? its not working.

Chandra kumar

[Former Member]

I want to check date comparision using select query

DATA : IMPODAY TYPE SY-DATUM.

IMPODAY ='20050117'.

SELECT * FROM ZMW0001 INTO TABLE SDYN_ITAB WHERE IMPORTDAY = IMPODAY.

I have declared importday as DATS type in table.

how to compare.? its not working.

Chandra kumar

[Former Member]

I know this is a silly question, but does ZMW0001 has an entry for IMPORTDAY - '20050117'.

Is sy-subrc = 4, after executing the query ?

Regards,

Subramanian V.

[Former Member]

Hai

i have solve this problem.

thanks