Formatting a date for usage in a filter

[Daryl_R_Weaver]

I am trying to extract info from a webpage and want to filter by time. The filter is set like this:

However it produces the following error:

Failed to evaluate filter ‘0-0’: Function ‘formatDate’ finished with error! ‘09:43:53’ is not a valid date.

It seems to me 09:43:53 is indeed a valid “date”. Is it because it is a time instead of a date? Any ideas on how to get this to work?

[Sakshi_agr12]

Hey @Daryl_R_Weaver

can you please send me the blueprint of the scenario?

[Daryl_R_Weaver]

Thanks for your reply. Attached is the blueprint.

This obviously is not complete. I am trying to get the filter figured out before I proceed with the rest of the building. That last Iterator is on there simply because I needed something to test my filter.

blueprint.json (12.1 KB)

[Sakshi_agr12]

@Daryl_R_Weaver
Use this in your filter.

[Daryl_R_Weaver]

Worked! Thanks for your help