Database query to find last stop date

[telecom engineer 0]

dear all ,

i am working on CRM(Customer relationship manegement) and i need to find customers that last connected in 10 days for example (inactive customers)

i have a table with start date and stop date , can i run query to know who was inactive for the last 10 days (for example stop date would be 19-Sep)

i need to know if it is doable at least .

 

thank you

[japet 0]

try this where clause... where to_date(sysdate, 'yyyy/mm/dd') - to_date(last_date, 'yyyy/mm/dd') > 10