ERPNext Foundation ERPNext Cloud Chat Blog Discuss Frappé* Donate

Datepicker Validation Not Working

custom_script

#1

I am using datepicker in custom script. It is working fine and I want to put a validation on startdate and end date as:

–> startdate shouldn’t be greater than enddate

–> enddate should be after of start date

This is my code:

 $('#start_date').datepicker({
  format: "yyyy/mm/dd",
  autoClose: true,
  autoOpen: false,
  language: 'en-US',
 onSelect: function(selected) {
alert(selected)
$('#end_date').datepicker("option", "minDate", selected);
        }
 });	
 $('#end_date').datepicker({
  format: "yyyy/mm/dd",
  autoClose: true,
  autoOpen: false,
language: 'en-US',
onSelect: function(selected) {
alert(selected)
$("#start_date").datepicker("option","maxDate",selected);
        }
 }); 

The alert I used is displaying the value ie date but validation isn’t working. Can anyone help me what I am doing wrong ??


#2

Let us know if this helps https://erpnext.org/docs/user/manual/en/customize-erpnext/custom-scripts/custom-script-examples/date-validation


#3

I am using html for making that field. So can you help me with this


#4

well ok I am on thin ice - for me to help you would need to teach me what you know :wink:


#5

It could be a great standard data type : Date Range
One field typed “date range” with option min and another field typed “date range” with option max


#6

Currently using ajax data-table for showing data as frappe data-table is having pagination issue right now. For that i simply created a table in html on form page and within that html code, i used a field for setting field. Now I am trying to put validations between those fields (described above). The websites to which I landed via Google, searching for this query, about every site told me the same but that didn’t worked.
I am using ERPNext v11 and it is currently using ES6 java-script standard so this might be the issue that some syntax or way of doing it might have changed (just a blind guess).


#7

Thanks for sharing, to explain your context engages others to follow you and learn

A reference implementation say for eg here may give you clues
https://datatables.net/examples/api/form.html

If a search of discuss.erpnext does not give you ideas to your question, a search on ‘datepicker’ ‘validation’ might land you some code to point the way https://datatables.net/forums/

Maybe share your datatable or any validation code for more context?

Syntax errors should show up in web console or server logs, depending on the case.


#8

There is an existing datatype in Frappe called “DateRange” that takes a 2-member list of the start and end dates, and automatically validates them. It’s already being used in a couple of reports.

Not sure about the best way to solve your problem, but you may have fewer headaches with this datatype.

Just my 2 cents.


#9

Thank you