regarding the select query

[Former Member]

hi,

select docnum from edidc

into table itab

where direct = '1'

and mestyp = 'OILORD '

and rcvpor = 'WBM6_OIL '

AND CREDAT = '07/10/2007'

and ( status = '03' or status ='30' or status = '22' or status = '06' or status = '12' ).

when iam using this statement the records are not retrieved from the database.

select docnum from edidc

into table itab

where direct = '1'

and mestyp = 'OILORD '

and rcvpor = 'WBM6_OIL '

and ( status = '03' or status ='30' or status = '22' or status = '06' or status = '12' ).

when iam using this statement the records are retrieved from the database.

iam unable to understand the problem.

please give the guidance for this.

it is very urgent.

thanks in advance...

[Former Member]

AND CREDAT = '20071002'.

regardss

Peram

[Former Member]

The date should be given as '07.10.2007'.Try this and see

Regards,

Reema.

[Former Member]

The field "CREDAT" is having values in the format of "YYYYMMDD" in the table EDIDC. So you have use the same format in the query.

For example,

CREADAT = '20070701'

[Former Member]

Hi,

Please see the format of date,whatever you give in quotes will be taken as a string input and will be matched char by char...if there is any small diff it will not be selected...CREDAT is of type DATS go to itns data element ie EDI_CCRDAT,

you will see that it is s Date field (YYYYMMDD) stored as char(8)

i think you got your answer.

thanks and regards

vivekanand

[Former Member]

date should be entered in <b>yyyymmdd</b> format for the field <b>CREDAT</b>.

regards,

srinivas

<b>*reward for useful answers*</b>

[Former Member]

Hi ,

In the table EDIDC the field CREDAT is stored as DD.MM.YYYY.

so, while writing the query you have to use that format.

Try like this.

rgds

harris