How can I disable products using rules?

Hello

I'm trying to create a rule that automatically disables products in the store

I have a view that lists all products (not product displays as I was getting duplicate results with this)

On the product entity, I have a date field where the user enters a date and time which is when the product should become disabled.,

I've set up a rule with a condition to compare current site time to the date field and an action which is evaluate component to disable the product, but the problem is which event to use to trigger the rule.

Ideally I'd like it to run on cron, but choosing 'Cron maintenance tasks are performed' as the event doesn't allow me to get the conditions and actions of the commerce products.

I've tried adding the commerce product is updated and commerce product is created events, but I don't want to have to go into add a newproduct or edit the product just to disable it as it kind of defeats the object.

Any help is greatfully appreciated as I've spent days on this
Thanks very much