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.