topic Re: want to create executable program which is having date field in selection in Application Development and Automation Discussions

want to create executable program which is having date field in selection

Former Member — Sat, 07 Aug 2010 17:31:12 GMT

Hi experts,

I want to create executable program which is having date field in selection screen. date is select-options field.

now my problem is i want to select the data from ztable.

the table contains many filed in that one field is from_date and another is to_date.

ex: from date: 01.01.2010 to date: 31.12.2010.

but in selection screen user will enter like:

ex: from date: 05.05.2010 ; to 31.05.2010.

now i want to search the user enter date range is between the ztable from and to dates.

in example above it is following in that range.

i want to select that record.

so how can i write select statement for this.

plz help me.

Harsha

Edited by: harsha82 on Aug 7, 2010 7:53 PM

Moderator message: duplicate post locked.

Edited by: Thomas Zloch on Aug 8, 2010 8:56 AM

Re: want to create executable program which is having date field in selection

Former Member — Sat, 07 Aug 2010 21:12:07 GMT

hello,

just a simple a select will do...

SELECT.....

....

WHERE zdate IN SO_DATERANGE " Date range on selection screen...

Thanks.

Re: want to create executable program which is having date field in selection

Danish — Sat, 07 Aug 2010 21:25:56 GMT

Hi,

if i understand your problem correctly you want the record to be selected between from_date & to_date.

take two parameters in the selection screen -

parameters fdate type ztabel-from_date.

parameters tdate type ztabel-to_date.

Now in your select statement

select *

from ztabel

into table itab

where from_date >= fdate and to_date <= tdate.

Cordially,

Danish

Re: want to create executable program which is having date field in selection

Former Member — Sun, 08 Aug 2010 06:00:08 GMT

Hi friends,

In ztable date range is more. like 01.01.2010 to 31.01.2010.

but screen level he will enter. ex 05.05.2010 to 02.06.2010

now it should search that records.

05.05.2010 to 02.06.2010 is between the table record 01.01.2010 to 31.01.2010.

now it should get that records.

but in ztable this date 05.05.2010 to 02.06.2010 will not be there.

regards

harsha.