🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

"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

Find more posts tagged with

AI Studio

Filtering

Accepted answers

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

All comments

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.