i need notification for visa expiry before 45days please tell me the condition
I haven’t tried but please try and apply it.
frappe.utils.getdate(doc.visa_valid_upto) <= frappe.utils.add_days(nowdate(), 45)
You don’t need to add a condition here.
The condition is to filter out documents and not to pick “days before”. Try it out with some test documents and click on “get alerts for today” to see if it works.
i didnt get you Ankush please explain detail