topic Re: time option in Application Development and Automation Discussions

time option

Former Member — Thu, 23 Oct 2008 02:54:51 GMT

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.

Re: time option

Former Member — Thu, 23 Oct 2008 02:57:38 GMT

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.

Re: time option

Former Member — Thu, 23 Oct 2008 02:58:29 GMT

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

you have from time > high timr

Re: time option

Former Member — Thu, 23 Oct 2008 03:10:13 GMT

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).

Re: time option

Former Member — Thu, 23 Oct 2008 03:10:31 GMT

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).

Re: time option

Former Member — Thu, 23 Oct 2008 03:26:40 GMT

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