"Filter examples by Date"

hughesfleming68

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?

Kind regards,

Alex

MartinLiebig

Hi Alex,

i would recommend to use the expression option in Filter Examples and write the statement there with the Generate Attribute syntax.

Best,

Martin

hughesfleming68

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!

Regards,

Alex

MartinLiebig

Alex,

i think you can do

date_str_custom(date_now(),"MM/dd/yyyy")

directly in Filter Examples.

Or use Generate Macro instead of Generate Macro + Extract Macro

~Martin

hughesfleming68

Thanks Martin,

You are right. Generating the macro is all you need. I have made the change.