Hi Michael, thanks for your response. I also found that there is apoc.periodic.schedule. However both iterate and schedule doesn't really solve my problem as each offer can be created at any time and I need to know exactly when to update the status.
For now I have created a new attribute in the node as expired_time, and I'm populating this the moment offer node is being created. And I'll only display those offer nodes when current_time < expired_time
So to confirm, there are no record level triggers available in Ne04j ?