Date field with time field over midnight

[jcarroll01]

I have 2 seperate fields as above, one date and one time. I'm trying to set a parameter for each that will get me all 15 minute time intervals in a range from two different days. (Call center time zone dilema)

e.g. - 10/31 to 11/1 from 8:00 pm to 8:00 am.

Seems to me the issue is that 8:00 pm to 8:00 am 20:00 to 08:00)isn't a logical range for time and it only gets 10/31 from 8 pm to midnight.

 

[lbass]

You could just use a record selection formula like:

datetime({table.date},{table.time}) in {?datetime} to {?datetime} + 1

Insert a group on date, then on date on change of hour, and then create a formula to group on:

select minute(datetime({table.date},{table.time}))
case 0 to 14 : "00 to 14"
case 15 to 29 : "15 to 29"
case 30 to 45 : "30 to 44"
case 45 to 59 : "45 to 59"

-LB