Filtering schedule between times.

[BFuchs]

Hi,

If we have a schedule table and using two fields ScheduleStartTime and ScheduleEndTime, both being date/time fields like 4/4/20 10:00 PM and 4/5/20 06:00 AM, how do I filter for all records being from 4/5/20 1:00AM to 5:00AM?

I need all schedules that falls partially between those timings?

See example attached.

thanks

[Vitalikssssss]

Hi @BFuchs,

You need to make sure that you select Date and Time type of precision in the filtering settings. 

Also, you need to setup a correct logic for filtering within a range of Date&Time values:

You may use a Submission Form which would pass a parameters from Virtual fields to Report Datapage.

Submission form should have separate Virtual fields for Date and Time input. Calculated value can be used to concatenate Date and Time input and pass it as a parameter to the next form.

Finally, you need to create a Report Datapage with predefined filtering criteria which will receive a filtering parameter. 

Here is an example of these Datapages deployed on single web-page.

You may also import this example into your account to check it further.

Hope this helps.

Regards,

vitalikssssss

TT_DATE_TIME_FILTER_1_0_2020-May-15_1247.zip