Email Notification Conditions

I am trying to set up a notification for reminding employees to follow up on old sales. I would like to remind them of sales 30+ days ago, but no longer than 90 days ago. I have tried multiple different ways to make a range like this but keep getting “invalid” errors when trying to save. This combination of “Days After” plus a condition allowed me to save:

Capture789 Capture7899

But then when trying to get alerts, I get this error:

TypeError: can't compare datetime.date to str

Is there a way to accomplish this? Thanks

You can try:
doc.due_date < frappe.utils.getdate(nowdate()), 90

1 Like