problem in select-options

[Former Member]

Hi all,

I am facing a problem in select-options. In the select statement

Select field1

field2

.

.

Where fieldname(in database table) IN field1.

Where field1 is date(dats format(yyyymmdd))

-When values are entered in select-option(field1), even though the values entered in selection-screen are there in database table it is not

Fetching any records. Please help me.

-I defined field1 as : field type databasetablename-fieldname.

POINTS WILL BE REWARDED.

Regards,

Venkata

[Former Member]

Pls could u send ur selection-screen definition and select statement..

[Former Member]

Pls write the code here.

rgds

Nishant

[Former Member]

Hi,

Please provide your actual select statement and the data definition of the field you are talking about. Also pleaes clarify where are you getting the date to use in where condition. Then only we can help.

Regards,

Rs

[Former Member]

i got the answer, i am closing this