Date comparison

So RM is finicky with the attributes you use for date_diff(). THey need to be in a numerical date-time format, hence 01-07-2015 might not work because RM considers that a polynominal/ Tha could be causing the error.

This is very easy to do, but you don't want to use date_diff here.  That's for computing the difference between two different dates.  Instead you want to use the following function: date_add(Date,-6,DATE_UNIT_MONTH)

(This assumes your existing date attribute is called "Date").  Just put this into Generate Attributes and create your new attribute accordingly.  You can also change the amont of the date change (in integers) and also the unit of change (days, months, hours, etc).

Thank you Thomas,

So how shoud define it?

A

@abbaszavar try using Nominal to Date operator. You will need to input the format of your date, so if you have 2017-01-18, then you must enter it as yyyy-MM-dd, then RapidMiner will automatically convert those values into date format. 

Thanks,

My original DATE1 has "date format" such as (Jun 30,2015), so I don't think I need to change its format, do I?

But when I follow the same format, it doesn't work again!

if(date_diff(DATE1,Jun 30,2015)>7776000000,1,0)

any advice?

Thanks

A