Jump to content

Skipping days on a schedule


dmp

Recommended Posts

Hi there,

I'm trying to figure out how I can do a merge of a 5 page schedule for Tuesday, Wednesday, Thursday, Friday, Saturday. (unique schedules for each day of the week) They want to skip Sunday & Monday because they are closed.

 

I need to have a variable date at the top that says:

Tuesday August 2 2016

All the way to:

Saturday December 30 2017

but skipping all the Sundays & Mondays.

Is there a way to do this with a rule?

My level of understanding in FP VDP Creator is fairly beginnerish...

(I'm on v9.3.21)

 

Thanks for the help you amazing people you.

Cheers,

Mikey

Link to comment
Share on other sites

This will give you an array of dates between 8/2 and 12/30 without Sundays and Mondays but I'm not really clear on what you're intending to do with it from there:

var start = new Date('8/2/2016');
var end = new Date('12/30/2017');

var dates = []; // Array to hold all the dates

// Push the current date into the 'dates' array
// and increment the date until we've reached the end
while (start <= end) { 
 dates.push(new Date(start))
 start.setDate(start.getDate()+1);
}

return dates
 // Remove dates the fall on Sunday or Monday
 .filter(function(date) {
   return date.getDay() > 1;
 })
 // Format the dates
 .map(function(date) {
   return FormatDate(date, 'ld lm d yyyy');
 })
 // Join the array with break tags
 .join('<br>\n');

Link to comment
Share on other sites

Thank you I will try this out.

 

It's a time schedule book for an office, This would be for the header that shows the date for each day (Minus Sunday & Monday since the office is closed those days)

Like this:

Tuesday August 1 2016

Name:

Time in time out

 

 

Wednesday August 2 2016

Name:

Time in Time out

 

etc... More detailed than that but should give you an idea of what I 'm trying to accomplish

http://forums.pti.com/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAM0AAAD/CAIAAADdbMWYAAATR0lEQVR4nO2dz2/b1h3ABfSyWw89DliA/gG57Dr0IPjUQwc0hyzy5sQu2mY/5K1dlqbKEFWx7CXOIi+Op8g1FWe1U0W2lziGw8x1MmGKW6TFXGjdxQm6FFKADQKUVNhB0C7iDl/kgSH5SImiHt+X/H7wEDAiTb4v30eP4ldPj5EjBDF4Imzp+vXrt2/fnp2d9a8yRGCJsKWtra2XXnqpVCrNz8+PjY35VyUigEQYc3NzkUjkhRde+Oijjw4dOhQhCLdYeKY9o9PpwEb79+9/+vSpRhCu6NYzplqn0/GxugRSevCMejXCNZaXTq5npBrhjp49owso4QI3noFq3377LalGdIlLz0A18ozokp49O/PG9c5Kp3P1WRntaD/UqFCBMv/9/jzbv3//+Ph4JBJ56Tvf63Q61JMRlvTlGXzwf/r06YsvvhiJRK5fv+7Os0ajsbu7q2na7u5urVbTNK1cLsO/5XIZVhmWYeNGo1Gr1eD1VqsFe6vVarBZrVaDvbEFF8D+y+Vy7RmsAvBffeXL5fLe3h5EVC6XoUr61wEWJoSgX/AQVjFYgCpBIKyGbGNY5XkdGO49Y3eXnU4HurRXXnnFXZe2u7s7FI22Wq3hWGwmk9nb2xuKRmu12sv79g3HYslkstFoGJZVVR2KRhuNRl5RhqLRoWh0OBaDdk0mk7C3crkM2wxFo/pzakO5XJ7JZGB5b28vmUzCgYaiUVVV84qSVxSoABw6ryjlcnk4FtM0bTgWG47FYEtYHo/H9a/Dnlut1lA0mkwmNU3LK0oymYR4Yf9MO7bcJVBbOAOwXKvVhqJRWIZ6wllSVVXTNFVVX963j70r4PT2Xw0e7j1jPnU6nUePHsEffPnlly48g1MPLToci60Ui3qf4L1oWB6KRuHNCo3darXG43FVVeHkwrKmaclkEux0rAOTQ1XVvb298Xh8KBrNKwo7hPZMC2ghS8+g5nlFgf1ACw3HYtCLQKurqgo7r9VqEDjbGN4hELt+2b7m+toaag5BsXcdqwnUajweB/X1b91yueyuGva49MxAp9P5wXdHIpHIyMiIu0tnMpkcj8fhHIEl5j5Mvwwdlfa8BHlFgZZeKRahL9nb22PvWnvgvEMbQB8JHhsOAVrwPIPKNxqNRqPBeg5oXbYwHo+zSmqaBq0L/VCr1WKNrV+2r7m+toaaszewpmn6/gwuIPBKq9Vip5T1uC6qYY9nnn305qORkZFHjx658ww6CegJXt63Dz73wAI7EfrlmUyGXXryilKr1eAMwp9DYTvp5r1Yq9VmMhnoCRqNxkqxCNK0Wi2Dyvrr5kwmAwfVNA0u+tBR5RVld3cXNtM3LXwYgAJ/xTTV98SGXtkefW1rtZq+5prOcjhQo9FotVozmQyrBntLwyl1XQ17PPPs84taP/eb0ADlchlU05515tAe5mUmVl5RYNVMJgNtCd0JdBjdewY0Gg12TuGtbOMZNAPrMFh3BVdGqBK8Dr2FqqrsIwF8aoRbBOYZ6zP0y13CamtY1nsGJ4r1eRAsdMDQ60Ml+6kGD288s9lR94ANrVaL3TlCe8B/DctsS+jhmEnsb9l++v8Yy3Zl3qe+tjbbsJqbt9cvDAL9ztk51J8TwykdUDUk8owIMOQZIQLyjBABeUaIgDwjRECeESIgzwgRkGeECLz07KgT8Xict+r1118fGx113IMMHDx4kLdqZGREZE1c4Nd59tKzz+5/7rpMT59bWV3rZw/CyujomO91QHeeB+uZkr/8lomJdHoQ8U+k0+ZjWbKxudnPgfr3rPuqmlHyl/s5dDfneRC1Is/IM/yeFYrFiXTaULKXcoPwLHspZz6WZbm99Ym/nnVfVXMpFIuD9szm6FeOH7908uTNn/+8+Ktf6ctmPi/Os5XVNfty9eMCb9Wvf31s9uKc4x5kKAcOHOCtWr76se/Vsy/9n+c7ufn1qx+b/7X/Ky89Kzhx6tQp3qqpqSlFURz3IAM2UUxOTs7NzS1KzAfJpC/n2UvPms1myUSz2WTbJBIJ3p+v37jx8OFDm/3Lg00Ua6urn3762b///R9py+Lioi/n2UvPqtWq+RNitVpl25BnvpcgePb4wYPU4cOGQp5JVYLgmfbkifbggbHoSCQS7Xa7+jywCpdnzWbTMgosnlUqlVwu1/+vS7pH6PebiUTCfG2FVbg8K5VKllFg8Qzqn8vlhJ008qxnyDMXiPaMtwqXZ7xVWDyrVqulUqlSqQg7aUI9O/r22w85zF64sL29zVsrFW/zo5jJZIrFlU8//UzaMjU5eevWLZGnC6D+rGcC0J+JPF0AedYz5JkLyLOeIc9cINozw3dTSPNn8DnaHAV5xsPnvEapVIJVuDwz5DVYFOQZD9Ge1ev1nA52a43LM8inm6Mgz3gI9cwmI0B5DUF5jXSa8hpo+jPeKurPeMjlmWESaDkhz1wgl2cw9aHkqpFnLpDLM5hIfKDzG/YPeeYCn+832ZABXJ/PDPebLAryjAeNC+qZAIwLEn/SfP4+AGme1vB9AOVpHZElfzY/P3/3zp3B5nA84mQiwVuVzWZXV1d9T5JR/izg+TP5o/CrhuRZz6DOApJnwfFM5iwgeRYcz2TOAkIN6/W6/ueAAqD8Wc/Y5M/kjwJqmMvl9OkYAVD+rGds8mfyRxEWz4KdP5M/iiB4lnDix8PDvFWxQ4fGx8cd9yADqKN4Y2xsfX1daOrs4cOH3ubPzHNnVKvVdrvNtkmE4z5AZGV6JQj3m/3PSyVz5olBnrlALs9kzjwxyDMXeOnZ//71r2+Xlgylp+umzJknBnnmAspr9AzqKMgz2VuIgTqKsHgWjPkc8UYRCs9OnDjBy68oCwtYxp+lUineKpiMU2RlesWvGtL36D2DOopQ9GeoW4iBOgtIngXHM5mzgGHxzPAJmj0tBZdn9lHInAUMi2fBmJcKbxTkmewtxEAdRVg8462Sv4UYqKMIhWc2+bNg/H6T8mc8qD/rGdRRhKI/Q515YpBnLpDLM5kzTwzyzAVyfY8uc+aJQd+ju4DGBfUM6ijIM9lbiIE6irB4xlslfwsxUEcRCs9snou4vLx87969ASVvvOXsmTO8VRdnZ32ZXax7/Koh9Wc9gzqKUPRnqFuIgToLSJ4FxzOZs4Bh8SwY87jYRyFzFjAsnuHNCDBQRxEWz4Ixzx7eKILg2fqNG/bll+PjvFXJZPLD+fm11VX5y3g8zosi9cEHl/N5x/PgY0meOpXNZgvC8dIzxyTK2bNneav+dOXK+vpN36fX76ZMTEzwolheWpI8C6goSm7+w5XVNcHF4+tmzgpVVWEbmzs1+Z8kwspvjh3jRSH/dbNQKKysrn12/3PBxWPP3rKCfXwhz3zH0TMlf9ld2djcFOXZkydqKmUuXywswDbkme84embZU3SDkr8syrNWS3vyxKI8yySBZyUT1WoVnWeWUZBngq6b9oBn5iqWSiV0nllGEQDPNjY33ZU7fy3J5Zn5RqFSqaDzzDKKAHiG4z7AHpvnIsr/REFWjh8/zotC/l8HLi4uplKnp6fPCS6yfI+Orj+zRP7+bHlpaXt7W7zf5Jn3ntG4IDPkmfee0bggM+SZ957RuCAzUtxvagg9s4xC/s9nUEPzcx09pF6vm48rRf5MQ+iZZRRYPDM/19FDLB8f64Nn5ky6htAzyygC4NmfX3tt6cAB879//NGPDK+cHx5eOnDAvLH/nr3/3nu8+97l5eWNmxu+58a6KZnz53lRXLt2bWdnx7tsgPfkQj4vFbr+zBIs/Zn445Jn5JkIyDPyTATkGXkmAinyGjQuSBjkGXkmghB5VjXRbDbReWYZBXnGQ5Z53XOXLmEZf/Zb/rzu8j/dkfJnyPozS6g/40Geee8ZjT8zQ5557xmNPzNDnnnvGY0/M0N5DZeeUV6jJ8gz8kwElD9z6Rnlz3rCS88STrz55pu8VSM/+cnRt4/+EgNjR47wojhy5Mi7777reB585Gc//WkQ8mfmd3m1Wm2327BNIhz3ATZnyXeC0J9pnHmp2EBe8sx3yDPyTASB8OzxY21ry6I8fgzbJDj3Ae12G51nllFg8axer1t+wvGEZrNpPq4UeY0qwvnPLKPA4lkul7O88ngCe5qCHvKMPHuO1OHDx8bGzP92/+LOX/5iPi597+TSM0uweFapVMy/PwX+vrLyj6Ulc7l/86b5FcuNHz94YD6uLM9FvHLlys2bSOZ1P32aF4X8T3cM+3MRqT8TQyDuN50IiWc0/swMeea9ZzT+zIz/36NDugWdZ5ZR0PgzHv7nNZDOF2QZBX0+4+H/PHuVSkVD6JllFOQZD/p85tIzS8gzHrLkz2YymWJxxffcWDfljdFRXhSzFy74Mmt691D+jPozEYSiPyPPfIc8I89EECLPaB5kHwmRZ+axKBpCzyyjIM94+J8/y9FzKgQSCs9snotI44LEcCmbzWazBeHQfYDL/swS+fszZWFh9uLcyuqa4EKeee+ZzOOCQvE84ZB4JvO4IHvPCsWikr/sutg8Ip08894zmccF2Xs2kU7zfp/SDRubmxJ5RvebPhIiz8z10xB6ZhkFds9ub32ysbnpuvzt3o5EntH3AT4ShPsAx0mR3gr6vFSHR0bGf/GL3xw7Jm0ZjsXGRkePCofuA1z2Z0ijWFxc9KXHFTFfEHxG1sgzCQp5JnsLkWf94PG8VH9+7TVzuXvyJGxDnvleAuGZE7y8RmDm25Y/CvJM9hYiz/rB/9+jVwM0r7v8UYTCs/ffe483LioYz0WUP4pz09NBmNfdHroP8L2Eoj8jz3wv5JnsLUSe9QN5Rp6JQIq8hoahhQyeIY2CPJO9hcizfpAif6ZhaCGDZ0ijCIVnJ06c4OVXrl69uoHk95uZ8+fxRjFN+TPJewJDf4Y0ilD0Z+SZ74U8k72FyLN+kOI+AMU30AbPkEYRIs+QjqgxeIY0CvJM9hYiz/qBPp+59AxpFKHwzGZe92w2u7oi9cgtVo4fP443iqnJSZrXXeqegPqzfiDPyDMRkGfkmQikmMcFRebJ4BnSKELkmTkjUK1W5W8hg2dIoyDPZG8h8qwfvPTM8eb27JkzvFXBmNdd/ig+nP/w66+/HohKtnjp2fT0OfsyOTXFW3V6YmLmD39AUX539izeKN555x3048/EzxJIpdcyPX3uIfbrpi8nznEqct+b1rHYT/p6e+sT8uy5HfnSSI5TRPuukWOxr/9EOk2ePbej21ufTKTThkKekWeat55tbG6Kb2bHqch918ix2F/3C8Uiefbcju4WCrmDBw3F91akoi9B8Gx2Ip19P2EoXeY1UqnTjmkRSQrqKOLxOPq8huPBbJ6/OTs7u7297Wlog8JmFJ38UVzKZv/51Vfd9kLe4aVn9Xrd/NSjer3OtrEZryH/EwUZjlGIrEyvBOF5wtVq1XwfABMCAIlEolqtmoc5aBieKMhIJBLNZtM86YFGnvHx0rP/3L+vvvqqoRg8K5VKliLK/0RBhmUUsIo84+GlZ+122/yrxna7zbZJJBKVSsXywip/CzHIMxfIMp5W/hZioI6CPJO9hRioowiFZzbzus/Pz9+9c2dw9/MecpI/r7v8UeRyOfT5M0dQ9wQM1FGEoj9D3UIM1FGExTPD/WalUoFV8rcQw5wFpPyZI6I9M2QE4LHiGoYWYqCOIiyeBaM/wxtFWDzjrZK/hRiooyDPZG8hBuooQuGZTf5MWViQPPPESKVSvFXyR0H5M9l7AgbqKELRn6FuIQbqUXRh8cw8XgNW4fLMPIoOVsk/ii4snuEdUcNwjELmUXRh8cy+J+i19r6AulcOi2e8VfK3EAN1FOSZ7C3EQB1FKDyzeS7itWvXdnZ2BpS88Za5uTneKvmjoPyZ7D0BA3UUoejPUGeeGOSZC+TKa8iceWLQ/aYL5PJM5swTA3UWMCye4f0lNwN1FjAsnvFWyd9CDNRRBMEzx5tbu/mCLlyQfKYdBupZj/yqoZeerd+4YV8m02neqvO///3y0pLjHmQok5OTeKOYmpryZZI2Lz1rNpuWTz1i26C+4jBQR1EoFFZW18TPIyl6Xiren8vfQgzUWcBuPPvbvR37KX9dzDzvpWePHzxIHT5sKOb5z5BmBBios4DdeGY5n7UN3cwI7qVn//3mm38sLRmK4boZBs9kzgIGwTNHEomEeY40WIXLM7xZwG48u/PXkv1U8y5mnqf8Wc+gjiII9wGOoG4hBuoolIWF2YtzK6trgotQz2xmRF9eXr53795gc4UeYfMUUfmjuJTNZrPZgnCoP+sZ1FH4VUOf7wPY3aj8mScGeeYCH37vpL8lRvTLRwbNS+UCuTyTOfPECIBnlUrFclzT4KDPZz1jzp8Zrv7+Vs8eqGEul7PMMw8O8qxnUEcBNfxiYUFNpVi5cvHioI8r1LPgjz+TPoqLs7O3bt365osvquUy+/frr74a9HGpP+sZ1FGE5T6At0r+FmKgHhcUFs/MYyFhFS7P7L9Hlzk7ExbPaFyQv4TFM/Mzh2FVkDzzt3r2QA1VVbWcl35w0OeznkEdhWX+jPK0MoI6CkN/Nnl38vyN80Hrz2wyT/I/UZCB+rmIkD8Tf1zqz3oGdRQo7gP+D0CKEtAE58alAAAAAElFTkSuQmCC

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...