Client Script Date Validation Issue

[Katie A]

I have a client script to validate that the date selected is on a weekday.

Catalog Client Script onSubmit

   var checkStartDayofWk = getDayofWk(start);
   if (checkStartDayofWk == false) {
   g_form.showFieldMsg('x_myscp_myapp_start_date', 'Selected dates must be on a weekday.','error');
   g_form.submitted = false;
   return false;
   }

   var userDate = new Date(dateVal);
   var userDay = userDate.getDay();
   if (userDay == 0 || userDay == 6) {
   return false;

However, there are random weekdays on the calendar that are returning the incorrect integer value.

0 should be Sunday and 6 should be Saturday.

However, I am seeing that Monday, November 23, 2015 is returning as 0 on the calendar. Saturday, November 21 is returning as a 5.

This is very inconsistent, some dates are correct but others are incorrect.

I ***suspect*** that maybe this issue is since the logic is executed on the CLIENT side rather than the SERVER.

I typically use a Script Include to run the validation on the server and return the value to the client to stop the form on submit.

However, getXMLWait is not available in scoped applications, therefore I cannot use script includes for validation.Access to getXMLWait is not available in scoped applications , what is workaround ?

Let me know if anyone has any suggestions to implement this on the client side to use the onsubmit to stop the submission.

[billi_lumley]

Thanks, I've posted a new question.  

[ndt13]

Does this work for just a date field?   (Not a date/time field)

I have a client script that calculates the difference between the start and end dates to return the number of days.   (Additional fields will appear depending on how many days the calculation spits out - For example, if it is a 3 day difference, then 3 fields appear.   If it is a 2 day difference, 2 fields appear.)   However, this script does not work correctly for users in Europe because they set their formats to dd/MM/yyyy instead of the system default of yyyy-MM-dd.

I haven't been successful in getting this to work for my date fields, so any help would be appreciated.

Thanks

[Katie A]

You should be able to use getDateFromFormat to validate dates in any of the date formats in the system.

var udate = getDateFromFormat(dateVal, g_user_date_format);

[ndt13]

I keep receiving this error message with the date fields:  

onChange script error: TypeError: Cannot read property 'split' of undefined function (){var o=i(m,arguments);return l.apply(n,o)}

This does not appear when I try it with date/time fields.

[Katie A]

I would actually suggest that you post your own question with your code in the Scripting section. I usually have responses to my questions immediately when I post there.