C:\Users\44739\AppData\Local\Temp\Engine_35548_4f6e487474114f6fb1c11ca8dc2bb76d_\Engine_37080_979aaff5a3634838988d67b8460501fa_.yxdb
Single
Profile
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAScQAAEnEB89x6jgAAABJ0RVh0U29mdHdhcmUAR3JlZW5zaG90XlUIBQAADRxJREFUeF7tnd+OFccRh/0GzhvEb4DfwH4D+w3sN0jewFxxhxIpcGEJCS4s+WKJsYR9w14kYq8WIWE2CgqKMVqL4FUQ8kIisCVL5NtTvZXa6j/TZ2fm7J51fWqNTtdU93QPU7+pnjNneetNEATBSgi5CYJgRYTcBEGwIk5Gbv7y5D83Hu2nSrAOPHny5O7du7u7u6keBMuzarl5/OLn97/49q0/fUNJpmAdCLkJxrNSubn37NVvPv2baM2ycvPjT7+c395DqhCsZApWSMhNMJ6Vys0n2z+o1iwlN1anWIgla7BCQm6C8ayH3Lz96Y62Crk5EUJugvGsh9zYViE3J0LITTCekJugi5CbYDwhN0EXITfBeEJugi5CboLxhNwEXYTcBOMZkJsff/rlj988+3jz+/e/+Na+MkN59/OH2Nl779mr5D3EycoN4zy/vff72/9iLmz5/OWjF2lfMETITTCeAbn54KvvbKjXyjvXHhDAgy/gLSU3f7j3b3SBgq7ZVmgcSmHLoABdffDcaaUW7PSAqibXEuz965P/Skmmxe8wRLlEvJJ1AbvUv92zok2sdvNZ+0mmCnaEM70GGXITjGdAbj7a3HXx2SiEbmpWYSm5sZ7t8t6f/5naZBCHTq2KBZ+GLljNRQTxRGLUIiW5LrB2TmCy1kEN1f+31/6erEffNvrd7SfJmuHm2HPEYxByE4xnQG6463LRE8+EHGJhCxYbD1LaiQatrHOyVrCe7dKQm3Of/yN3luLsRGxqk2GdmXWeKLkBWHkalGCwg+QUJesiv1M7pXZuUSLrttbZzf7+PocAPiRTk9evX4s/JFOdTjdFBsMhUn3Bsp3s7e25TsTCNtVLFH0GW4GM2Z09LNYo1R7Ef0LGPip2CjKh3ORKUSs2RC3ucFRtCsNnF6i1fnJtcsUlFDce7du97d++ow7W2YmFPQmsWPMUjBOuDpTaFMYzq9wQCTdv3rx8+fIFA9XNzU0X7QLGra2tK1euJNdDsOzs7CSnDPG5detWqjd5+PCh+Lspi5HRpnqT27dvi7/t5LPPPsPCNtVLFH0WPV24f/9+qpeQI7JN9QXSUI1S7UFOwsWLFxsyxy5xvnPnTjLVGSs37nKfUG6UpQ6huDAmU0g7jmIVh3hO1qPkckNah8QwknvPXrHNVYA1kTq3Vzc2hXFZEtC/7qW4JRXHZcy6F21KO2ZgPrkhfuR6LcK1zkWfXBdwfWNMuxcQltaC6BTDI+2+cGEwR4BLly6Jc1FuYPBUoIk6qgnlph3808oNzoOjHXSwnFm5sTpiH4g4iFh1oxQ7d3JDVNsHukVc3pTrkWKF6eqD58lqcCfNjtAdZXBUY5hJbrglLi7sA4gHG0gciyQC+8bGRjId1Rr2Wn9SJHqQvcWYlFYwGBtWAWtyM9iJRL4wodwAelpM+kAOqsoiSCtnVBibOBT/cTmrsreYVemJaiig5czKjX2uVEttBKsmjDBZDdaBbnui2uVWRR0Bm7zQc02Viksqd1qKI5+QOeSGa1Qu1sYdG7sNLV1AuZRHwV8UB89kOgSjSlVjIpqVSILjPBetUz+NdU2jk5FyI93WVnOTyw1In6xtncbpHDvXp3A25ebYo/rgq++S1WDlJl/v1LAaUewWbHrSWHO56ciSyvZPitRIoCZhDrmRoILOe6PeS2uRI2j8ODkQI7HBluBJ1gyJLtxkeG7KB10sBsC20YnkZWzzTopS4ij6YAE9CUWxk4G58yP+tZOmp6vxjyui6XqQY6E4ToYanE25cd/pJGsFO6qimhxPbuzX25SiHNgUrD0vt2768OvHttpzTkYyudxoll67UedIatNzfTfCVe/JxXCVvXII6aQoN9pJMYZlajjwIe+kODZH0QcL8EG0DHKZFglwoxLn4lChR27UhxmJRf/5amlmkbMpN2QKtkmyVphJbtAXbUXJ11P2C6zG0yWB3uxTHlsk2ZmbyeVG79Kd1ysRLv498qSPhFJ9gVoat2WJZInMXCngoItFJzL+Y3RSlBJH0QcL8IEjivLmCxyZmlOWRbtRcgMbGxv4XL9+Xao9s8jpkhuu9S8fvTi/vcdNVd6j1eJeojslcmMFguLG7Ir9cmdCuQGrehwoWQ+xe3skw50HKStYRgmTy40EBnSupDQqamFjKYaQWORzcXUgd2x2SQxLRLkpH3RxtBP35EJTm1onPYFa9MEC8lkfUWn8C3JW3bwW7cbKDfOSI+KmTTTZ6WRAbh6/+Pnjze/dJd4op1Nu+su0cuNewLHv1Ljcx71uU8MtqSgr+w8t5pObVB9CL/Fa2FjU2Q5YLPJZcxMbMHID10VWrhRw0MVhJ3oU24m00pdQ8k6KUuIo+mCBVKk8yZKz6k5R7mYpnqsikjMyKhlezz+EoyU35P+1nxrVyhxy4x6CzCo3xee1x5YbsCsg+wWZndS57vdlnPL2vLI8FfPJTecdUqOi5yovhpBYUuUwpHVpJk1IWKQK4uCmfNBF1ommGD2diIVtqpco+mCBVFkgj71B+5ez6k6R+NTOm4wZ3EyL6DeDmgMuRVVuuN86rSEq0AsKd1Suey3Wh2pqX+J4cuNatQ8hWIFg2DrUwZLaH2WM3NjB299J2D7zxzo1mIu2kkL/ad/MzCc3nX2yfBD/HrmR12HBaplYUsWEmazmarrghrdo8f9OdFTiJk00P4Jat2xTvUTRBwukyiHu8fnccqMndqknxEpVbuwPf9ovm6gbpRaxwonIzfgUYIzcuBdwZNHkjJ0PX9x50DLr233K5HKjF26PfAjyrCR/oSZHbvs2y4DF0Y6Eq6yeiGpZmLjwlph3Uz7o4mgn8mAYZ4nbwU70oKleQlo5HyyQKoegp/JIRU7L3HKzlHNOVW7sBd1+Tc56nkK5oSTrcRkjN2Cby5m039M3Xrex2BcCXWn8uHRCJpcbkDhpvL3ikMAevNa5z0vPulASpG2qLCBWxSj+7qF1rhSwcPed6ETYOv+8E1EEmqR6CRHWomqkikGFG5FdS7khpO0F3Y7wfs+VyY1rMvK7m5FyYx/TyM+y7Jqo81mvbUKy6V4sYr7JbzbmkBuJDahFgkPVgTt548GBqpJdSYEYU+UQffzhtAk65QZ0Ii4fgbwTXX/ZNZdFQ9rJnxhT5Sg6C1lbrbfcJGsF67mU3BxvEdEjN278/Q9HioyUG6ZpX+ez6jP4uo3gxEVSJDsqytxLqjnkRtMQqP2emECyQqCBTVw5NQE6vH79ujjkHYo9VQ6RMUDeW7/cLNuJGPHPzycSg529uXIdHLgiNyB9CustN+0I7/c8hnCAC7aedMB9zZy/87IUI+UG3GuHWnpet3HP7HUA2K2Kzb2kmkNuQKMLWIygERxC4LMsT1wYa/ICiMvW1harCbbYtas8VQHZlSoGxAJSxdAvN7BUJ0xHh8oUdnZ2FjPe3dzcFCN7XWoDsitVMji69rlmcuOeFDSyA/fUs60g9sZO6Xxs4bSvs5WL8DEJzni5cVPQIk+O29ijoy+2STHrmYmZ5AaIK1kCFCFc88BjGSJPN3Kw1xYp4pAqHSwlNzWKnUBj1kwhnzLI3lQpoVqwZnID9s75zrUHeWAgSfkbgNxj5e8Hk1DkEZ4/78RTeiYfkReX80WBUzSK/l1ktv2tcCsu3xqHFsbLDeQ/QTjX8bqNE5T8GY0dG0mQnJY5mE9uBDIUUhKCk1s08cYHllHtw9GEENrY2MCZLZ+xpH0lcINU6YAB4O8if5JOFJSRkYvuMGs+17QSeg7NGcg7kYa1nhmbONQGaVnKOacqN/kLrCiI/AcGH3792L74XyvFb6BrP/zRMvib7GIpLiXc2k0KnjIR+UGGnUhtPTKJ3OSDGUy40A67jCrKk1PVkcvGBnPLTfBroCo33PMHpYGCT0ML8nyhtqzQUhSpPC3KS3I9Su2hSa0U059J5CbPtorHsrgTW0u+nJDNtKQKuQnGU5Ub4PrOX2O1hQyImCGQ7MpLi3vQoHBXL/pLqf1pmBuP9hutGguTPE1rlOKAJ5EbsP0MPoFyz7nQlLSjhP1nmmlJFXITjKclNwLXPRKgmQ4xT9hwC7U3Zz4TP+rD1U+QNy56/OmBbulKOqQQUbUbuFBsxYEGv6tiJAyvoVaMvDFgBiZt2Q6ugBowcj3i4JiZqUxQ5pisFThv6kxpn8bjEXITjGdYbs4SxCFxjnxIIaRZ3M2RC+RwFNUaZCtZ14eQm2A8vy65OUHsmm4wWzmFhNwE4wm5WQUsA+13TKvJp6Yl5CYYT8jNKmDhplrz3oiHzSdIyE0wnpCb2bn37JVNbdovXp9aQm6C8YTczAhrqPPbe1Zr1jS1gZCbYDwhNxODoCAr7x79i/FS3q7/x3Wnn5CbYDwhNxPjJEYLWjPH6zArI+QmGE/IzcQ4lZHy0ebu+uY1QshNMJ6Qm4nR957ZfrL9w9UHz9fxa++cly9fPn36NP/zUUHQT8hNEAQrIuQmCIIVEXITBMFKePPmf4GyDTAL6GK4AAAAAElFTkSuQmCC
Weekly Challenge #253
C:\Users\44739\AppData\Local\Temp\Engine_35548_4f6e487474114f6fb1c11ca8dc2bb76d_\Engine_37080_a4300523bc4d49ad9e673b8302bbe850_.yxdb
Single
Profile
Jean Guy
2020-12-27
California
Douglas Bell
2020-12-27
Minnesota
Michelle Johnston
2020-12-27
Iowa
Sean Blohm
2020-12-27
Texas
Nellie Gillon
2020-12-27
Missouri
Doris Stanley
2020-12-27
Michigan
Jeffrey Atkins
2020-12-27
Virginia
Gwen Schenck
2020-12-27
Wisconsin
Sara Todd
2020-12-27
Virginia
Robert Merry
2020-12-27
Pennsylvania
Robert Tompkins
2020-12-28
Oklahoma
Rico McNeill
2020-12-28
Pennsylvania
Lisa Burrell
2020-12-28
Tennessee
Nicholas Vela
2020-12-28
California
Walker Baldwin
2020-12-28
Washington DC
Amanda Wasinger
2020-12-28
Minnesota
Kevin Vecchio
2020-12-28
Washington
Jesus Pratt
2020-12-28
Arizona
Harriette Taylor
2020-12-28
Florida
Brandon Teegarden
2020-12-28
Illinois
Sarah Martinez
2020-12-28
Pennsylvania
Julie Frierson
2020-12-29
Oregon
Jeffrey West
2020-12-29
California
Sharon Moore
2020-12-29
Arizona
Brenda Chambers
2020-12-29
Mississippi
Ardis Xiong
2020-12-29
Florida
Kathryn Deel
2020-12-30
Wyoming
Anthony Foster
2020-12-30
Florida
Roy Thurston
2020-12-30
Hawaii
Joseph Batchelor
2020-12-30
Michigan
Ricky Watson
2020-12-30
Texas
John Norman
2020-12-30
Massachusetts
Felipe McFadden
2020-12-30
Virginia
Robert Gillespie
2021-01-03
Pennsylvania
Freda Hayden
2021-01-03
Florida
Franklin Gibson
2021-01-03
Utah
Darren Harless
2021-01-03
Alabama
Amy Molina
2021-01-03
California
Rose Richardson
2021-01-03
Michigan
Diana Jensen
2021-01-03
Vermont
Derek Lis
2021-01-03
Arizona
Alabama
5
Arizona
10
California
3
Florida
5
Hawaii
15
Illinois
10
Iowa
10
Massachusetts
8
Michigan
10
Minnesota
7
Mississippi
15
Missouri
11
Oklahoma
8
Oregon
13
Pennsylvania
9
Tennessee
11
Texas
12
Utah
17
Vermont
7
Virginia
8
Washington
3
Washington DC
3
Wisconsin
11
Wyoming
18
Jean Guy
2020-12-30
Your order is scheduled for delivery on Wednesday, 30 December, 2020
Nicholas Vela
2020-12-31
Your order is scheduled for delivery on Thursday, 31 December, 2020
Kevin Vecchio
2020-12-31
Your order is scheduled for delivery on Thursday, 31 December, 2020
Walker Baldwin
2020-12-31
Your order is scheduled for delivery on Thursday, 31 December, 2020
Jeffrey West
2021-01-01
Your order is scheduled for delivery on Friday, 01 January, 2021
Anthony Foster
2021-01-04
Your order is scheduled for delivery on Monday, 04 January, 2021
Amanda Wasinger
2021-01-04
Your order is scheduled for delivery on Monday, 04 January, 2021
Jeffrey Atkins
2021-01-04
Your order is scheduled for delivery on Monday, 04 January, 2021
Sara Todd
2021-01-04
Your order is scheduled for delivery on Monday, 04 January, 2021
Harriette Taylor
2021-01-04
Your order is scheduled for delivery on Monday, 04 January, 2021
Ardis Xiong
2021-01-04
Your order is scheduled for delivery on Monday, 04 January, 2021
Douglas Bell
2021-01-04
Your order is scheduled for delivery on Monday, 04 January, 2021
Robert Tompkins
2021-01-05
Your order is scheduled for delivery on Tuesday, 05 January, 2021
Robert Merry
2021-01-05
Your order is scheduled for delivery on Tuesday, 05 January, 2021
Amy Molina
2021-01-06
Your order is scheduled for delivery on Wednesday, 06 January, 2021
Michelle Johnston
2021-01-06
Your order is scheduled for delivery on Wednesday, 06 January, 2021
Doris Stanley
2021-01-06
Your order is scheduled for delivery on Wednesday, 06 January, 2021
Rico McNeill
2021-01-06
Your order is scheduled for delivery on Wednesday, 06 January, 2021
Sarah Martinez
2021-01-06
Your order is scheduled for delivery on Wednesday, 06 January, 2021
Jesus Pratt
2021-01-07
Your order is scheduled for delivery on Thursday, 07 January, 2021
Brandon Teegarden
2021-01-07
Your order is scheduled for delivery on Thursday, 07 January, 2021
John Norman
2021-01-07
Your order is scheduled for delivery on Thursday, 07 January, 2021
Nellie Gillon
2021-01-07
Your order is scheduled for delivery on Thursday, 07 January, 2021
Felipe McFadden
2021-01-07
Your order is scheduled for delivery on Thursday, 07 January, 2021
Gwen Schenck
2021-01-07
Your order is scheduled for delivery on Thursday, 07 January, 2021
Darren Harless
2021-01-08
Your order is scheduled for delivery on Friday, 08 January, 2021
Sharon Moore
2021-01-08
Your order is scheduled for delivery on Friday, 08 January, 2021
Freda Hayden
2021-01-08
Your order is scheduled for delivery on Friday, 08 January, 2021
Lisa Burrell
2021-01-08
Your order is scheduled for delivery on Friday, 08 January, 2021
Sean Blohm
2021-01-08
Your order is scheduled for delivery on Friday, 08 January, 2021
Julie Frierson
2021-01-11
Your order is scheduled for delivery on Monday, 11 January, 2021
Ricky Watson
2021-01-11
Your order is scheduled for delivery on Monday, 11 January, 2021
Joseph Batchelor
2021-01-11
Your order is scheduled for delivery on Monday, 11 January, 2021
Diana Jensen
2021-01-11
Your order is scheduled for delivery on Monday, 11 January, 2021
Robert Gillespie
2021-01-12
Your order is scheduled for delivery on Tuesday, 12 January, 2021
Derek Lis
2021-01-13
Your order is scheduled for delivery on Wednesday, 13 January, 2021
Rose Richardson
2021-01-13
Your order is scheduled for delivery on Wednesday, 13 January, 2021
Brenda Chambers
2021-01-13
Your order is scheduled for delivery on Wednesday, 13 January, 2021
Roy Thurston
2021-01-14
Your order is scheduled for delivery on Thursday, 14 January, 2021
Kathryn Deel
2021-01-18
Your order is scheduled for delivery on Monday, 18 January, 2021
Franklin Gibson
2021-01-20
Your order is scheduled for delivery on Wednesday, 20 January, 2021
C:\Users\44739\AppData\Local\Temp\Engine_35548_4f6e487474114f6fb1c11ca8dc2bb76d_\Engine_37080_a65ee1928725437cacf6849c1838da8b_.yxdb
Single
Profile
C:\Users\44739\AppData\Local\Temp\Engine_35548_4f6e487474114f6fb1c11ca8dc2bb76d_\Engine_37080_7bd137669f57435a9c415d551c54b923_.yxdb
Single
Profile
FINAL CLEANING
Delivery Date - Ascending
Delivery Date
English
day, dd Month, yyyy
DateTime_Out
Convert Delivery Date To:
day, dd Month, yyyy
Join back on customer
Sort dates oldest to newest
Obtain new full delivery date as per output
Form message as per output
Remove unwanted fields
DEAL WITH DELIVERY DATES ON A WEEKEND
Delivery Date
English
day
DateTime_Out
Convert Delivery Date To:
Custom
DateTime_Out = IF [DateTime_Out] = "Saturday" THEN "Monday"
ELSEIF [DateTime_Ou...
Delivery Date = IF [DateTime_Out] = "Saturday" THEN DateTimeAdd([Delivery Date],...
Create day of week from delivery date
If day of week = either Sat or Sun, change to Mon
If day of week = Sat, add 2 days to original delivery date
If day of week = Sun, add 1 day to original delivery date
Remove fields in prep for join
DATA PREP
Join on State
ffefef
Join on state
Calculate delivery date
Change data type
Horizontal
Weekly Challenge 253