topic Re: date comparision in select. in Application Development and Automation Discussions

date comparision in select.

Former Member — Mon, 17 Jan 2005 06:06:17 GMT

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 — Mon, 17 Jan 2005 06:11:47 GMT

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 — Mon, 17 Jan 2005 07:07:05 GMT

Hai

i have solve this problem.

thanks