How to select data from Datatable using Only year

[Former Member]

Hi SAP-gurus

i want to select data from table using select-options from a date field but unavailable to do that.

the select-option format is given below.

please give me a solution 

Thanks & Regards

RKarmakar

Moderator message: Please do some research before posting, Its not that hard.

Message was edited by: Kesavadas Thekkillath

[Former Member]

Hi Raju,

U can try the below workaround :

On the selection screen, have the select - options for the Date. And then, Using String Offset operations extract the lower and Higher value of the Year and use it in your query. U should be able to proceed.

Thanks

Vivek

[RaymondGiuseppi]

Here you only put PARAMETERS, read again SELECT-OPTIONS statement definition. Then use the select-options in a IN range option of a WHERE clause of an OPEN-SQL statement.

Regards,

Raymond