Filtering on a data set by date

davidb

in sql depending on type there are various ways to filter by date on days. Is there a way to easily do this in rapidminer operators? For example if I only wanted to capture data that goes back 180 days from today (date now)?

davidb

Thanks, I this is what I ended up doing. 
seemed easier to manage the dates after converting them to epoch

generate attributes:
date_millis(date_now())-15552000000

generate second attribute converting date to epoch again:

date_millis(TEST_DATE)

Then filter based on expression

test_date_epoch>=date180_epoch

kayman

You could generate a new attribute containing the time difference between your date field and now, there are quite some date options available in the operator. Then you filter using this new attribute and remove it again. Not the most elegant way but it does the trick

davidb

Thanks, I this is what I ended up doing. 
seemed easier to manage the dates after converting them to epoch

generate attributes:
date_millis(date_now())-15552000000

generate second attribute converting date to epoch again:

date_millis(TEST_DATE)

Then filter based on expression

test_date_epoch>=date180_epoch