2 Date compare and validation
Marek_Lefek
Customer Advanced IT Monkey ✭✭✭
Hi, I was wondering does anyone has to solve the problem with validation one date from another form the form prompt.
I have form with 2 dates that describes specified period: field Date_from and Date_to.
I need to validate form that always Date_to >=Date_from.
Without fulfils this condition, users should not save the form.
0
Best Answer
-
Konstantin_Slavin-Bo
Customer Ninja IT Monkey ✭✭✭✭
There's no OOB solution to this, but you can take a look at John Doyle's RO Toolbox here:
https://community.cireson.com/discussion/comment/8550/#Comment_8550
It includes a solution to exactly this problem, where you first set a Display Only prompt "@DateRange" and right afterwards add your two date prompts. The RO Toolbox will then hide the Display Only prompt, and make the two date prompts behave like what you describe.
5
Answers
https://community.cireson.com/discussion/comment/8550/#Comment_8550
It includes a solution to exactly this problem, where you first set a Display Only prompt "@DateRange" and right afterwards add your two date prompts. The RO Toolbox will then hide the Display Only prompt, and make the two date prompts behave like what you describe.
Thanks for your help, but it won't works. I have prompts as below:
- @DateRange / Display only / Text
- Date1 / Required / Date
- Date2 / Required / Date
but nothing happened. Of course the RO Toolbox works - I test @AutoComplete with success.Could you try to copy/paste this code into the browsers devtool console (F12 > Console), and see if it works? And if it gives any errors, please copy them back here.
function parseOptions(controlName, control) {<br> var properties = "{}";<br> var regExp = /({[^}]+})/;<br> var matches = regExp.exec(control.text());<br> if (matches && matches[1])<br> properties = matches[1];<br> console.log(controlName);<br> console.log(properties);<br> return JSON.parse(properties);<br>}<br><br>function createDateRange(tag, tagElement) {<br> var userDefined = parseOptions(tag, tagElement);<br> var startDate = tagElement.next();<br> var endDate = startDate.next();<br> tagElement.addClass("custom-item-daterange");<br> tagElement.html("<div class='col-md-4 col-xs-12 startdate'></div><div class='col-md-4 col-xs-12 enddate'></div>");<br> startDate.find("div.col-md-4").removeClass("col-md-4");<br> endDate.find("div.col-md-4").removeClass("col-md-4");<br> function startChange() {<br> var startDate = startDatePicker.value()<br> , endDate = endDatePicker.value();<br><br> if (startDate) {<br> startDate = new Date(startDate);<br> startDate.setDate(startDate.getDate());<br> endDatePicker.min(startDate);<br> } else if (endDate) {<br> startDatePicker.max(new Date(endDate));<br> } else {<br> endDate = new Date();<br> startDatePicker.max(endDate);<br> endDatePicker.min(endDate);<br> }<br> }<br><br> function endChange() {<br> var endDate = endDatePicker.value()<br> , startDate = startDatePicker.value();<br><br> if (endDate) {<br> endDate = new Date(endDate);<br> endDate.setDate(endDate.getDate());<br> startDatePicker.max(endDate);<br> } else if (startDate) {<br> endDatePicker.min(new Date(startDate));<br> } else {<br> endDate = new Date();<br> startDatePicker.max(endDate);<br> endDatePicker.min(endDate);<br> }<br> }<br><br> var startDatePicker = startDate.find('input[data-control="dateTimePicker"]').data("kendoDateTimePicker");<br> startDatePicker.bind("change", startChange);<br> var endDatePicker = endDate.find('input[data-control="dateTimePicker"]').data("kendoDateTimePicker");<br> endDatePicker.bind("change", endChange);<br> startDatePicker.max(endDatePicker.value());<br> endDatePicker.min(startDatePicker.value());<br> startDate.detach().appendTo(tagElement.find("div.startdate"));<br> endDate.detach().appendTo(tagElement.find("div.enddate"));<br>}<br><br>$("p:contains('@DateRange')").parent().parent().each(function() {<br> createDateRange("@DateRange", $(this))<br>});<br>I try to set the maximum range of Date2 prompt and the @DataRange don't work. When remove the range in Config Prompt it wokrs.
I configure it according to post https://community.cireson.com/discussion/comment/10730#Comment_10730Konstantin_Slavin-Bo
Aha okay. Yeah, it seems there's something overriding the values, which are set on the custom date pickers, with the values from RO config, each time the field is in focus. I'll see if I can find a fix for this, but I can't make any promises on neither time or success.