time option

[Former Member]

Hi,

in my report selection screen. i have fields like following.

i have a from date and to date

and from time and to time

if i am select from date is 21.10.2008 to date is 23.10.2008

from time is 13:00:34 to time is 12:00:45

if i am execute the s.s it shows the following error in status bar.

from time is greater than to time.

how can solve this problem.

[Former Member]

if i am select from date is 21.10.2008 to date is 23.10.2008

from time is 13:00:34 to time is 12:00:45

if i am execute the s.s it shows the following error in status bar.

from time is greater than to time.

how can solve this problem.//

Obviously u 'll get the error as 13:00 is greater than 12:00

make the time stamp as 11:00:xx to 12:00:xx and get rid of the error

Vijay.

[Former Member]

hi, we are retriving the datas from Z Table with in th s.s date and time limit, if the from date is higher than the to date it will show som e errror . the time can be anything right.

example. we are getting data from 21.10.2008 (10:00:34) to 23.10.2008 (08.10.22).

[Former Member]

how can a high value field be less than the low value

you have from time > high timr

[Former Member]

hi, we are retriving the datas from Z Table with in th s.s date and time limit, if the from date is higher than the to date it will show som e errror . the time can be anything right.

example. we are getting data from 21.10.2008 (10:00:34) to 23.10.2008 (08.10.22).

[Former Member]

You are correct .

Use select-options for date

select records that fall in that date period.

sort the internal table by date and time.

delete records from internal table which wont fulfill start time and similarly with end time.

As records are sorted depending on date and time it must produce result