Help evaluate datetime

[cjany]

I'm writing in CR8.5 against an informix v7 database.
I present my users with two parameters (date and time)
In my select expert, I need to evaluate the following

If datetime({?date},{?time}) in datetime({?date,083000}) to datetime({?date,085900}) then {db.app_time}

what this is attempting to filter is the presence of any time between the date my users select and the times between 8:30 and 8:59.

I can't seem to get this to work for me, any help would be great.

 

[lbass]

Not sure why you are using a time parameter, if you are specifying the time frame. Your record selection formula could look like the following if you wanted to limit records to those on the user selected date for your specified time period:

{db.app_time} in datetime({?date},time(08,30,00)) to datetime({?date},time(08,59,00))

-LB