Validate mindate and maxdate between two columns

[gonleyParticipant]

When I edit a row with start date or end date, how do I get the value of another column in the same row and compare each other so that start date won’t be after end date and end date won’t be before start date using validation?

[Peter StoevKeymaster]

Hi gonley,

If you use Cell Editing, you may use the “getcellvalue” for getting the value of another Cell. If you use Popup Editing, then you may get the DateTimeInput’s Values using the “val” method of DateTimeInput before clicking the “Save” button. For “Full Row” edit, you will have to add “createeditor” callback functions to your Date columns, then bind to “change” event of jqxDateTimeInput and add some custom variables which save the current DateTimeInput value in its “change” handler. In the columns “validation” callback functions, compare your custom variables and return true or false depending on the result.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[Author]

Posts