Need notification for visa expiry before 45 days

Hi Friends,
i need notification for visa expiry before 45days please tell me the condition

Hi @sathya_raj,

I haven’t tried but please try and apply it.

frappe.utils.getdate(doc.visa_valid_upto) <= frappe.utils.add_days(nowdate(), 45)

Thank You!

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.

1 Like

i didnt get you Ankush please explain detail