topic Re: How to select data from Datatable using Only year in Application Development and Automation Discussions

How to select data from Datatable using Only year

Former Member — Fri, 12 Apr 2013 06:08:22 GMT

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

Re: How to select data from Datatable using Only year

Former Member — Fri, 12 Apr 2013 07:32:18 GMT

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

Re: How to select data from Datatable using Only year

RaymondGiuseppi — Fri, 12 Apr 2013 07:37:55 GMT

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