Filtering on a data set by date

davidbdavidb Member Posts: 3 Contributor I
edited October 2019 in Help
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)?
Tghadially

Best Answer

  • davidbdavidb Posts: 3 Contributor I
    Solution Accepted
    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


Answers

  • kaymankayman Member Posts: 463   Unicorn
    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
Sign In or Register to comment.