Date Validation Script from Documentation not working

Vesper_Solutions · February 3, 2021, 5:48pm

I created my own Doctype called “Staff Policies and Procedures”. I wanted to validate a date field with the fieldname “date” to limit the user to not select future dates. So i copied the date validate code from the documentation, made the required changes but the script does not work and the form saves even if I select a future date. Here is my code

frappe.ui.form.on(“Staff Policies and Procedures”, “validate”, function(frm) {
if (frm.doc.date > get_today()) {
frappe.msgprint(__(“You can not select future date in From Date”));
frappe.validated = false;
}
});

antzforwork · February 4, 2021, 6:52am

Hi @Vesper_Solutions did you already define get_today() ??
Maybe try using frappe.datetime.get_today(), it’s build in function from Frappe to get today.

Vesper_Solutions · February 4, 2021, 9:32am

Tried it, doesn’t work. Here’s the code:

frappe.ui.form.on(“Staff Policies and Procedures”, “validate”, function(frm) {
if (frm.doc.date > frappe.datetime.get_today()) {
frappe.msgprint(__(“You can not select future date in From Date”));
frappe.validated = false;
}
});

antzforwork · February 4, 2021, 10:52am

Hmm that’s weird.
Maybe try to frappe.msgprint before if
To see is the hook works or not…

Vesper_Solutions · February 4, 2021, 6:57pm

The hook works, I have used it in other validation conditions for other doctypes. The issue lies elsewhere.

iRaySpace · February 5, 2021, 7:38am

Hello.

You might want to look up this.

Regards,

Ivan

Vesper_Solutions · February 5, 2021, 9:38am

Mate it’s literally in the code I wrote:

frappe.ui.form.on(“Staff Policies and Procedures”, “validate”, function(frm) {
     if (frm.doc.date > frappe.datetime.get_today()) {
          frappe.msgprint(__(“You can not select future date in From Date”));
          frappe.validated = false;
     }
});

Doesn’t work

iRaySpace · February 5, 2021, 1:27pm

Hello,

Please check.

frappe.datetime.get_today()
frappe.datetime.get_day_diff("2016-05-05", "2016-05-03" )
frappe.datetime.add_days("2016-05-03", 2)

Regards,

Ivan

szufisher · February 5, 2021, 2:48pm

pay attention to the quote around validate.

Vesper_Solutions · February 5, 2021, 6:54pm

Working now, thanks

Abdullah_A_Ansari · February 17, 2022, 10:10am

I have created sales order as an Accounting Dimension but while making a payment entry, the following error pops up when we click in the sales order feild on payment entry form. No solutions till now.