dmp Posted June 10, 2016 Share Posted June 10, 2016 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 Quote Link to comment Share on other sites More sharing options...
step Posted June 10, 2016 Share Posted June 10, 2016 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'); Quote Link to comment Share on other sites More sharing options...
dmp Posted June 10, 2016 Author Share Posted June 10, 2016 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.