Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
workorder # | scheduled finished |
100 | 8/4/2013 |
101 | 8/5/2013 |
102 | 8/6/2013 |
103 | 8/7/2013 |
104 | 8/8/2013 |
105 | 8/9/2013 |
106 | 8/10/2013 |
107 | 8/11/2013 |
108 | 8/12/2013 |
109 | 8/13/2013 |
110 | 8/14/2013 |
111 | 8/15/2013 |
112 | 8/16/2013 |
113 | 8/17/2013 |
114 | 8/18/2013 |
115 | 8/19/2013 |
116 | 8/20/2013 |
117 | 8/21/2013 |
118 | 8/22/2013 |
i need to be able to count the number of work orders completed from 7-14 days from the previous Sunday, so dates 8/4-8/11
See attached example.
when i try implementing the solution for another problem the max date i'm getting is from 2019 is there a way to limit modify the solution
for example
workorder # | scheduled finished | Day |
100 | 8/4/2013 | sun |
101 | 8/5/2013 | mon |
102 | 8/6/2013 | tue |
103 | 8/7/2013 | wed |
104 | 8/8/2013 | thu |
105 | 8/9/2013 | fri |
106 | 8/10/2013 | sat |
107 | 8/11/2013 | sun |
108 | 8/12/2013 | mon |
109 | 8/13/2013 | tue |
110 | 8/14/2013 | wed |
111 | 8/15/2013 | thu |
112 | 8/16/2013 | fri |
113 | 8/17/2013 | sat |
114 | 8/18/2013 | sun |
115 | 8/19/2013 | mon |
116 | 8/20/2013 | tue |
117 | 8/21/2013 | wed |
118 | 8/22/2013 | thu |
119 | 8/23/2013 | fri |
120 | 8/24/2013 | sat |
121 | 8/25/2013 | sun |
122 | 8/26/2013 | mon |
123 | 8/27/2013 | tue |
124 | 8/28/2013 | wed |
125 | 8/29/2013 | thu |
126 | 8/30/2013 | fri |
With this data i still only want data back 7-14 days from 8/18/2013
See attached example