SQL Error :Message=ORA-00932: inconsistent datatypes: expected NUMBER got Date

[Abc11]

Hi to All,

Below is my Query.getting error message: expected NUMBER got Date

DATEADD function is not available in my SQL. Please, help me

With My_CTE as
(select laborcode,workdate,
(DENSE_RANK() OVER (PARTITION BY LABORCODE ORDER BY WORKDATE ASC)-workdate) col1
from bi_hz_etl.lem_facts_v )

select count(*) CNT, min(workdate), max(workdate) from My_CTE Group by Col1

Thanks

[Abc11]

Solved by this

(workdate-DENSE_RANK() OVER (PARTITION BY laborcode order BY workdate ASC))