I am having difficulty with the Filter Examples operator with regards to filtering dates.
I am start off by generating a Macro to return the current date/time when I run the process. I would like to use this to filter examples prior to the current date but how to do I get from the format Mar 17,2017 12:16:18 PM CET to 03/23/2017 which the Filter examples operater expects?
Solved! Go to Solution.
i would recommend to use the expression option in Filter Examples and write the statement there with the Generate Attribute syntax.
Here is how I did it if anyone needs to do this.
Generate Attribute with the following function expression:- date_str_custom(date_now(),"MM/dd/yyyy")
Extract the Macro
Filter Examples with the default "custom_filters" and add the macro.
I am sure there are other ways but this did the job. Many thanks to Martin!
i think you can do
directly in Filter Examples.
Or use Generate Macro instead of Generate Macro + Extract Macro