Skip to Content
0
Former Member
Aug 07, 2010 at 03:25 PM

Doubt on Dates

12 Views

Hi exports,

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