Jump to content
  • 0

Filtering schedule between times.


BFuchs

Question

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

Capture.PNG

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hi @BFuchs,

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

WWv3p3C.png

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

TCgGHT3.png

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...