CR XI
Oracle DB
Problem: I have a field that is calculated in the db to create what is called a split dateTime. This is calculated from two other fields StartDateTime and EndDateTime. The ranges between these fields can last several days. When I try to use the split date time (in certain date ranges), I receive a Database Connection error that indicates "hour must be between 0 and 23." I think that one of these calculations in the database resulted in a midnight time of either 00:00:00 or 24:00:00 in one or more records.
I am having trouble writing a formula for the selection editor to not use any "time" not in the 1 to 23 hour range. I realize I can create my own split time formulas from the Start and Ending Date/Time field which I had done in the past before the DBA created the splitTime field.
The Selection Formula I am experimenting with: (timevalue({Split.dateTime})) in timevalue(00,00,01) to timevalue(23,59,59)
This doesn't seem to solve the problem. Any thoughts?
Oracle DB
Problem: I have a field that is calculated in the db to create what is called a split dateTime. This is calculated from two other fields StartDateTime and EndDateTime. The ranges between these fields can last several days. When I try to use the split date time (in certain date ranges), I receive a Database Connection error that indicates "hour must be between 0 and 23." I think that one of these calculations in the database resulted in a midnight time of either 00:00:00 or 24:00:00 in one or more records.
I am having trouble writing a formula for the selection editor to not use any "time" not in the 1 to 23 hour range. I realize I can create my own split time formulas from the Start and Ending Date/Time field which I had done in the past before the DBA created the splitTime field.
The Selection Formula I am experimenting with: (timevalue({Split.dateTime})) in timevalue(00,00,01) to timevalue(23,59,59)
This doesn't seem to solve the problem. Any thoughts?