5464 Error: A search condition must be deterministic error while creating a join index

Database
Fan

5464 Error: A search condition must be deterministic error while creating a join index

Hi,

I am trying to create a join index on a table based on a date range.

create join index financial.idx_cust_present_ji

as

select cust_id, c_name, city,date_spent

from financial.cust_present_1

where cast(date_spent as date format 'yyyymmdd') > '20150101'; 

---where extract(year from date_spent) = 2015

;