Date Field Format

[radhushankar]

Hi all

i have to develop a report in that i have three input fields namely by material number ,customer number and date. In this i have used select options for date field.

i have to retrieve the data from vbak table with corresponding to the input fields when comparing the date field in the select query i am facing a problem that the date which i entered in the selection screen coming in a different format like this <b>IEQ2007080700000000</b> becauase of this its skipping the selection crieteria..but i want it should be like this <b>07.08.2007</b> ..can any one plz advice me to solve this issue..

Thanks in advance.

[Former Member]

Hi Radhu

let me know r u giving both low and high values,

Best Regds,

Kiran.M

[Former Member]

Hi,

You are givign the correct one, if you look at the value in the debuggin it will come in that way only, In the Select statment you need to use IN operator ..

Regards

Sudheer

[Former Member]

Hi!

Use the following syntax in your SELECT staement:

...

WHERE vbak~audat IN date "date is your select options

The following syntax is WRONG when you are using select options

WHERE vbak~audat = date

Regards

Tamá