Answers

• allan Posts: 64,925Questions: 1Answers: 10,753 Site admin

  January 2017

  Basically do as you have done using new Date() but add 4 days to it:

  var date = new Date();
  date.setDate( date.getDate()+4 );
  

  Allan
• tbrcrl Posts: 13Questions: 6Answers: 0

  January 2017

  Thank, Allan, it works fine!
  Any suggestion how to simply exclude the 'disableDays' from the counting?
• allan Posts: 64,925Questions: 1Answers: 10,753 Site admin

  January 2017

  No - I'm afraid that would need to be taken into the calculation. I suspect Moment will have a way of adding only working days.

  Allan
• tbrcrl Posts: 13Questions: 6Answers: 0

  January 2017

  Hi, I solved using pure JavaScript in this way

          var startDate = new Date();
          var cntrDate = new Date();
  
          var endDate = "", noOfDaysToAdd = 4, count = 0;
          while(count < noOfDaysToAdd){
            endDate = new Date(cntrDate.setDate(cntrDate.getDate() + 1));
            if(endDate.getDay() != 0 && endDate.getDay() != 6){
              count++;
            }
          }
  
          startDate.setDate( startDate.getDate()-1 );
  
          var editor = new $.fn.dataTable.Editor( {
          ...
           fields: [
           ...
           {
                "label": "DATE:",
                "name": "date",
                "type": "datetime",
                "format": "ddd, D MMM YY",
                opts: {
                  disableDays: [ 0, 6 ],
                  minDate: startDate,
                  maxDate: endDate
                }
             },
  

  Just one last question. I noticed that in order to be able to choose "today" on the datepicker I need to set the "startDate" the day before, or in other words

      startDate.setDate( startDate.getDate()-1 );
  

  There is a specific reason or I am doing something wrong?

  Thanks
• allan Posts: 64,925Questions: 1Answers: 10,753 Site admin

  January 2017 Answer ✓

  Very nice - thanks for sharing your code with us!

  . I noticed that in order to be able to choose "today" on the datepicker I need to set the "startDate" the day before, or in other words

  That's basically an artefact of the way the dates are being set to exactly midnight for each date in the calendar, and that you are passing in a date / time that is not midnight. If you set the time of your date object to be exactly midnight, it should work as expected.

  Allan