Skip to main content
Solved

How do I filter using time (HH:MM:SS) ranges?

  • April 10, 2017
  • 2 replies
  • 68 views
W
Forum|alt.badge.img

Hello Everyone,

I would like to build a workflow that would prompt users to enter a range (or ranges!) of time (HH:MM:SS to HH:MM:SS) that would be used as a filter an Excel sheet for rows within the ranges. Unfortunately, the AttributeRangeFilter will not permit this time format and I do not want to ask the user to convert to Epoch Time themselves.

Any helpful advice will be appreciated

Best answer by erik_jan

How about using the DateFormatter (format "%H%M%S") to convert both the parameter and the data to numeric values.

Then you could use the AttributeRangeFilter to compare the two.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

erik_jan
Contributor
Forum|alt.badge.img+23
  • erik_janContributor
  • Contributor
  • Best Answer
  • April 10, 2017

How about using the DateFormatter (format "%H%M%S") to convert both the parameter and the data to numeric values.

Then you could use the AttributeRangeFilter to compare the two.

W
Forum|alt.badge.img
  • wellis11
  • Author
  • May 1, 2017

Hello Erik_jan. Thank you for your response. The automated conversion to epoch time was pretty easy as long as I clearly communicated the data entry format to my users. The problem is in feeding the time ranges (plural, and an unknown number of ranges) into a test filter so that records from another table can be retained only if they fall within the specified ranges. At this point my problem is beyond dates, so I think I should create a new thread.

Community Stats

32,154
Posts
122,047
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.