RapidMiner

Filter examples by Date

SOLVED
Regular Contributor

Filter examples by Date

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

4 REPLIES
Moderator

Re: Filter examples by Date

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

--------------------------------------------------------------------------
Head of Data Science Services at RapidMiner
Regular Contributor

Re: Filter examples by Date

[ Edited ]

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

Highlighted
Moderator

Re: Filter examples by Date

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

--------------------------------------------------------------------------
Head of Data Science Services at RapidMiner
Regular Contributor

Re: Filter examples by Date

Thanks Martin,

 

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