Difference of two dates?
I'm trying to filter the examples I have so that the date in one attribute is always smaller than in another. Basically, what I need is that "If date1 < date2 then keep the example, otherwise throw it away".
I can't seem to be able to do this very easily (but I suspect this should be an easy operation). Filter Examples doesn't seem to accept dates. When I convert my two attributes to integers, then Filter Examples complains that the left hand side attribute is not numerical (it is!) when I try to use the attribute_value_filter with "date1_day > date2_day". So I searched for something else and wanted to try the Generate Aggregates function so I can create a new attribute that's either larger than zero or not, but the function does only sums and such, whereas I would need to subtract one from the other number.
As I think I'm beginning to overcomplicate the solution I would appreciate if someone could help me out with some hints.
Thanks
I can't seem to be able to do this very easily (but I suspect this should be an easy operation). Filter Examples doesn't seem to accept dates. When I convert my two attributes to integers, then Filter Examples complains that the left hand side attribute is not numerical (it is!) when I try to use the attribute_value_filter with "date1_day > date2_day". So I searched for something else and wanted to try the Generate Aggregates function so I can create a new attribute that's either larger than zero or not, but the function does only sums and such, whereas I would need to subtract one from the other number.
As I think I'm beginning to overcomplicate the solution I would appreciate if someone could help me out with some hints.
Thanks