0.00.0100005050NY50000YN1000100-2020/07/18 15:51:30.580-2020/07/18 15:51:30.580H4sIAAAAAAAAAAMAAAAAAAAAAAA=NModified Java Script ValueDummy (do nothing) 2YData GridModified Java Script ValueYData GridDataGridY1nonedataInteger-1-1N13280YDummy (do nothing) 2DummyY1none512144YModified Java Script ValueScriptValueModY1noneN90Script 1//Script here
const date = new Date('2020-07-01')
const daysToAdd = mapToWorkdays(date, -10)
date.setUTCDate(date.getUTCDate() + daysToAdd)
var mysa =( date.toISOString().split('T')[0] )
document.write ( date.toISOString().split('T')[0] )
var d = ( date.toISOString().split('T')[0] )
// prints 2000-03-24
/**
* @param {Date} date starting date
* @param {number} add number of workdays to add
* @return {number} total number of days to add to reach correct date
*/
function mapToWorkdays(date, add) {
const wd = weekday(date)
let r = Math.trunc(add / 5) * 2
const rem = add % 5
if (wd > 4) r += (6-wd)
else if (wd+rem > 4) r += 2
return add + r
}
/**
* @param {Date} date
* @return {number} day of the week in range of 0..6 (monday..sunday)
*/
function weekday(date) { return (date.getUTCDay()+ 6) % 7 }mysamysaDate-1-1N272144YN