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
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.
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.