Check Calendar for Double Bookings

Hi heget‌,

It uses the date/time picker control, so not 24hr format. Just the value selected in your control. Also you can have any label applied to your save button.

What issues were you facing?

So I've chcked in Mozilla debugger and get this error on opening form.

RangeError: invalid date NewForm.aspx:1504:19
GetISODateString https://URL/Lists/SPZ1/NewForm.aspx:1504:19
CheckDates https://URL/Lists/SPZ1/NewForm.aspx:1517:31
<anonymous>

var isoDate = new Date(fullDate.getTime() - (fullDate.getTimezoneOffset() * 60000)).toISOString();

Any help ?

Hi @heget,

I've updated @shaneoss' script so that it works for dates with a spaces in their formatting.

there are several bugs in NINTEX code that cause NINTEX do not correctly works with date formats that include a space, or include (accidentally) one more space, or doesn't include a space but space is expected, or a different separator is used then expected, etc.,

PLENTY OF problem in date/time handling in nintex products, especially if you use other then EN/US locale.

unfortunatelly, NINTEX refuses to fix it!

may I ask you what exact locale do you use?

could you perharps log an incident with NINTEX support that you experience problems with these date formats?

if they had more incidents reported for the problem, they might, hopefully, took it a bit more seriously...

@heget check out @emha's modified version of my script. If your still having issues let me know and what locale your using. Then i'll update my to match mine and do some further testing.Thanks!

Hi @bdupree,

We have a resource called HotDesk which is a list lookup to another list on the site referencing a single line of text field on the list.

You can see in the code below in the CAML the resource (HotDesk) is added.

Easier to copy andpaste into Notepad++

 var startDate = NWF$("#" + StartTime).val();

 var endDate = NWF$("#" + EndTime).val();

 var hotDesk = NWF$("#" + HotDesk).val();

 if (startDate != "" && endDate != "" && hotDesk != "")

 {

  if (hotDesk.indexOf(";#") != -1)

  {

   var hotDeskval = hotDesk.split(";#");

   hotDesk = hotDeskval[1];

  }

  var startHours = NWF$('#' + StartTime).parent().find("select[id*='DateHours']").val(); 

  var startMinutes = NWF$('#' + StartTime).parent().find("select[id*='DateMinutes']").val();

  var endHours = NWF$('#' + EndTime).parent().find("select[id*='DateHours']").val();

  var endMinutes = NWF$('#' + EndTime).parent().find("select[id*='DateMinutes']").val();

  var isoStartDateStr = GetISODateString(startDate, startHours, startMinutes); 

  var isoEndDateStr = GetISODateString(endDate, endHours, endMinutes);

  var clientContext = SP.ClientContext.get_current();

  var web = clientContext.get_web();

  var list = web.get_lists().getByTitle('Region Hot Desks');

  var camlQuery = new SP.CamlQuery();

  var query = String.format("<View><Query><Where><And><Or><Or><And><Leq><FieldRef Name='EventDate' /><Value Type='DateTime' IncludeTimeValue='TRUE'>{0}</Value></Leq><Gt><FieldRef Name='EndDate' /><Value Type='DateTime' IncludeTimeValue='TRUE'>{0}</Value></Gt></And><And><Lt><FieldRef Name='EventDate' /><Value Type='DateTime' IncludeTimeValue='TRUE'>{1}</Value></Lt><Geq><FieldRef Name='EndDate' /><Value Type='DateTime' IncludeTimeValue='TRUE'>{1}</Value></Geq></And></Or><Or><And><Leq><FieldRef Name='EventDate' /><Value Type='DateTime' IncludeTimeValue='TRUE'>{0}</Value></Leq><Geq><FieldRef Name='EndDate' /><Value Type='DateTime' IncludeTimeValue='TRUE'>{1}</Value></Geq></And><And><Geq><FieldRef Name='EventDate' /><Value Type='DateTime' IncludeTimeValue='TRUE'>{0}</Value></Geq><Leq><FieldRef Name='EndDate' /><Value Type='DateTime' IncludeTimeValue='TRUE'>{1}</Value></Leq></And></Or></Or><Eq><FieldRef Name='Hot_x0020_Desk' /><Value Type='Text'>{2}</Value></Eq></And></Where></Query></View>", isoStartDateStr, isoEndDateStr, hotDesk);

  var currentItemID = GetUrlKeyValue("ID");

  if (currentItemID != "")

   query = String.format("<View><Query><Where><And><And><Or><Or><And><Leq><FieldRef Name='EventDate' /><Value Type='DateTime' IncludeTimeValue='TRUE'>{0}</Value></Leq><Gt><FieldRef Name='EndDate' /><Value Type='DateTime' IncludeTimeValue='TRUE'>{0}</Value></Gt></And><And><Lt><FieldRef Name='EventDate' /><Value Type='DateTime' IncludeTimeValue='TRUE'>{1}</Value></Lt><Geq><FieldRef Name='EndDate' /><Value Type='DateTime' IncludeTimeValue='TRUE'>{1}</Value></Geq></And></Or><Or><And><Leq><FieldRef Name='EventDate' /><Value Type='DateTime' IncludeTimeValue='TRUE'>{0}</Value></Leq><Geq><FieldRef Name='EndDate' /><Value Type='DateTime' IncludeTimeValue='TRUE'>{1}</Value></Geq></And><And><Geq><FieldRef Name='EventDate' /><Value Type='DateTime' IncludeTimeValue='TRUE'>{0}</Value></Geq><Leq><FieldRef Name='EndDate' /><Value Type='DateTime' IncludeTimeValue='TRUE'>{1}</Value></Leq></And></Or></Or><Neq><FieldRef Name='ID' /><Value Type='Integer'>{2}</Value></Neq></And><Eq><FieldRef Name='Hot_x0020_Desk' /><Value Type='Text'>{3}</Value></Eq></And></Where></Query></View>", isoStartDateStr, isoEndDateStr, currentItemID, hotDesk);

  camlQuery.set_viewXml(query);

  var listItems = list.getItems(camlQuery);

  clientContext.load(listItems);

First CAML (end):

<Eq><FieldRef Name='Hot_x0020_Desk' /><Value Type='Text'>{2}</Value></Eq></And></Where></Query></View>", isoStartDateStr, isoEndDateStr, hotDesk);

Second CAML (end):

<Eq><FieldRef Name='Hot_x0020_Desk' /><Value Type='Text'>{3}</Value></Eq></And></Where></Query></View>", isoStartDateStr, isoEndDateStr, currentItemID, hotDesk);

Note there's the additional <And> at the beginning accompanying the closing tag.

If you needed to add additional resources say up to three you'd need to update the queries to include your additional fields.

Hope this helps. :)