Spreadsheet: 122123d1316621937-if-a-row-of-data-has-a-date-less-than-todays-date-how-do-you-pull-all-that-data-helpforlateitems
Sheet: Data

Status | Order | Part Number | Operation | Oper Description | [NAME] | Complete | Due Date | Remaing Hrs | [NAME] | [NAME]
STARTED | 1 | 100 | 20 | test | 600 | 205 | 2011-09-12 00:00:00 | 39.5 | test | test | 40798_1
STARTED | 2 | 101 | 20 | test | 100 | 41 | 2011-09-12 00:00:00 | 11.8 | test | test | 40798_2
STARTED | 3 | 102 | 20 | test | 180 | 123 | 2011-09-26 00:00:00 | 7.14 | test | test | 40812_1
WAITING | 4 | 103 | 10 | test | 20 | 0 | 2011-07-20 00:00:00 | 1 | test | test | 40744_1
WAITING | 5 | 104 | 20 | test | 25 | 0 | 2011-08-02 00:00:00 | 2.5 | test | test | 40757_1
WAITING | 6 | 105 | 10 | test | 200 | 0 | 2011-08-09 00:00:00 | 20 | test | test | 40764_1
WAITING | 7 | 106 | 20 | test | 100 | 0 | 2011-08-09 00:00:00 | 10 | test | test | 40764_2
WAITING | 8 | 107 | 10 | test | 25 | 0 | 2011-08-18 00:00:00 | 2.5 | test | test | 40773_1
WAITING | 9 | 108 | 20 | test | 25 | 0 | 2011-08-24 00:00:00 | 2.5 | test | test | 40779_1
WAITING | 10 | 109 | 20 | test | 120 | 0 | 2011-08-24 00:00:00 | 12 | test | test | 40779_2
WAITING | 11 | 110 | 20 | test | 24 | 0 | 2011-08-24 00:00:00 | 4 | test | test | 40779_3
WAITING | 12 | 111 | 20 | test | 6 | 0 | 2011-08-24 00:00:00 | 1 | test | test | 40779_4
WAITING | 13 | 112 | 20 | test | 39 | 0 | 2011-08-29 00:00:00 | 3.9 | test | test | 40784_1
WAITING | 14 | 113 | 10 | test | 25 | 0 | 2011-08-30 00:00:00 | 4.17 | test | test | 40785_1
WAITING | 15 | 114 | 10 | test | 30 | 0 | 2011-08-31 00:00:00 | 3 | test | test | 40786_1
WAITING | 16 | 115 | 10 | test | 30 | 0 | 2011-08-31 00:00:00 | 3 | test | test | 40786_2
WAITING | 17 | 116 | 10 | test | 6 | 0 | 2011-08-31 00:00:00 | 1 | test | test | 40786_3
WAITING | 18 | 117 | 10 | test | 40 | 0 | 2011-09-01 00:00:00 | 5.01 | test | test | 40787_1
WAITING | 19 | 118 | 10 | test | 30 | 0 | 2011-09-02 00:00:00 | 1.5 | test | test | 40788_1
WAITING | 20 | 119 | 20 | test | 144 | 0 | 2011-09-05 00:00:00 | 14.4 | test | test | 40791_1
WAITING | 21 | 120 | 20 | test | 36 | 0 | 2011-09-05 00:00:00 | 6 | test | test | 40791_2
WAITING | 22 | 121 | 20 | test | 24 | 0 | 2011-09-05 00:00:00 | 4.8 | test | test | 40791_3
WAITING | 23 | 122 | 10 | test | 15 | 0 | 2011-09-06 00:00:00 | 0.75 | test | test | 40792_1
WAITING | 24 | 123 | 10 | test | 15 | 0 | 2011-09-06 00:00:00 | 0.75 | test | test | 40792_2
WAITING | 25 | 124 | 10 | test | 10 | 0 | 2011-09-06 00:00:00 | 0.5 | test | test | 40792_3
WAITING | 26 | 125 | 20 | test | 800 | 0 | 2011-09-12 00:00:00 | 80 | test | test | 40798_3
WAITING | 27 | 126 | 20 | test | 600 | 0 | 2011-09-12 00:00:00 | 60 | test | test | 40798_4
WAITING | 28 | 127 | 10 | test | 50 | 0 | 2011-09-13 00:00:00 | 5 | test | test | 40799_1
WAITING | 29 | 128 | 10 | test | 60 | 0 | 2011-09-14 00:00:00 | 6 | test | test | 40800_1
WAITING | 30 | 129 | 10 | test | 10 | 0 | 2011-09-14 00:00:00 | 0.5 | test | test | 40800_2
WAITING | 31 | 130 | 10 | test | 20 | 0 | 2011-09-14 00:00:00 | 1 | test | test | 40800_3
WAITING | 32 | 131 | 10 | test | 5 | 0 | 2011-09-19 00:00:00 | 0.33 | test | test | 40805_1
WAITING | 33 | 132 | 10 | test | 198 | 0 | 2011-09-20 00:00:00 | 6.59 | test | test | 40806_1
WAITING | 34 | 133 | 20 | test | 10 | 0 | 2011-09-20 00:00:00 | 1.43 | test | test | 40806_2
WAITING | 35 | 134 | 10 | test | 20 | 0 | 2011-09-22 00:00:00 | 2.5 | test | test | 40808_1
WAITING | 36 | 135 | 20 | test | 20 | 0 | 2011-09-22 00:00:00 | 2.5 | test | test | 40808_2
WAITING | 37 | 136 | 10 | test | 100 | 0 | 2011-09-22 00:00:00 | 10 | test | test | 40808_3
WAITING | 38 | 137 | 20 | test | 200 | 0 | 2011-09-22 00:00:00 | 20 | test | test | 40808_4
WAITING | 39 | 138 | 10 | test | 20 | 0 | 2011-09-22 00:00:00 | 2 | test | test | 40808_5
WAITING | 40 | 139 | 20 | test | 20 | 0 | 2011-09-22 00:00:00 | 2 | test | test | 40808_6
WAITING | 41 | 140 | 20 | test | 20 | 0 | 2011-09-22 00:00:00 | 2 | test | test | 40808_7
WAITING | 42 | 141 | 10 | test | 8 | 0 | 2011-09-22 00:00:00 | 1.14 | test | test | 40808_8
WAITING | 43 | 142 | 10 | test | 40 | 0 | 2011-09-22 00:00:00 | 2 | test | test | 40808_9
WAITING | 44 | 143 | 10 | test | 4 | 0 | 2011-09-22 00:00:00 | 0.2 | test | test | 40808_10
WAITING | 45 | 144 | 10 | test | 10 | 0 | 2011-09-22 00:00:00 | 0.5 | test | test | 40808_11
WAITING | 46 | 145 | 10 | test | 3 | 0 | 2011-09-26 00:00:00 | 0.3 | test | test | 40812_2
WAITING | 47 | 146 | 20 | test | 50 | 0 | 2011-09-26 00:00:00 | 6.26 | test | test | 40812_3
WAITING | 48 | 147 | 10 | test | 18 | 0 | 2011-09-26 00:00:00 | 1.8 | test | test | 40812_4
WAITING | 49 | 148 | 20 | test | 180 | 0 | 2011-09-26 00:00:00 | 18 | test | test | 40812_5
WAITING | 50 | 149 | 20 | test | 25 | 0 | 2011-09-26 00:00:00 | 2.5 | test | test | 40812_6
WAITING | 51 | 150 | 20 | test | 25 | 0 | 2011-09-26 00:00:00 | 2.5 | test | test | 40812_7
WAITING | 52 | 151 | 10 | test | 10 | 0 | 2011-09-26 00:00:00 | 1.43 | test | test | 40812_8
WAITING | 53 | 152 | 10 | test | 7 | 0 | 2011-09-26 00:00:00 | 1.4 | test | test | 40812_9
WAITING | 54 | 153 | 20 | test | 6 | 0 | 2011-09-26 00:00:00 | 1.2 | test | test | 40812_10
WAITING | 55 | 154 | 20 | test | 6 | 0 | 2011-09-26 00:00:00 | 1.2 | test | test | 40812_11
WAITING | 56 | 155 | 10 | test | 1 | 0 | 2011-09-26 00:00:00 | 0.05 | test | test | 40812_12
WAITING | 57 | 156 | 10 | test | 14 | 0 | 2011-09-26 00:00:00 | 0.7 | test | test | 40812_13
WAITING | 58 | 157 | 10 | test | 100 | 0 | 2011-09-26 00:00:00 | 5 | test | test | 40812_14
WAITING | 59 | 158 | 10 | test | 11 | 0 | 2011-09-26 00:00:00 | 0.55 | test | test | 40812_15
WAITING | 60 | 159 | 10 | test | 4 | 0 | 2011-09-26 00:00:00 | 0.2 | test | test | 40812_16
WAITING | 61 | 160 | 10 | test | 11 | 0 | 2011-09-26 00:00:00 | 0.55 | test | test | 40812_17
WAITING | 62 | 161 | 10 | test | 12 | 0 | 2011-09-26 00:00:00 | 0.6 | test | test | 40812_18
WAITING | 63 | 162 | 10 | test | 3 | 0 | 2011-09-26 00:00:00 | 0.15 | test | test | 40812_19
WAITING | 64 | 163 | 20 | test | 6 | 0 | 2011-09-26 00:00:00 | 0.86 | test | test | 40812_20
WAITING | 65 | 164 | 20 | test | 5 | 0 | 2011-09-27 00:00:00 | 0.5 | test | test | 40813_1
WAITING | 66 | 165 | 20 | test | 27 | 0 | 2011-09-27 00:00:00 | 2.7 | test | test | 40813_2
WAITING | 67 | 166 | 10 | test | 3 | 0 | 2011-09-28 00:00:00 | 0.6 | test | test | 40814_1
WAITING | 68 | 167 | 10 | test | 4 | 0 | 2011-09-28 00:00:00 | 0.2 | test | test | 40814_2
WAITING | 69 | 168 | 10 | test | 3 | 0 | 2011-09-28 00:00:00 | 0.15 | test | test | 40814_3
WAITING | 70 | 169 | 10 | test | 610 | 0 | 2011-09-29 00:00:00 | 20.31 | test | test | 40815_1
WAITING | 71 | 170 | 20 | test | 10 | 0 | 2011-09-29 00:00:00 | 1.25 | test | test | 40815_2
WAITING | 72 | 171 | 20 | test | 100 | 0 | 2011-09-29 00:00:00 | 12.52 | test | test | 40815_3
WAITING | 73 | 172 | 20 | test | 600 | 0 | 2011-09-29 00:00:00 | 60 | test | test | 40815_4
WAITING | 74 | 173 | 10 | test | 4 | 0 | 2011-09-29 00:00:00 | 0.4 | test | test | 40815_5
WAITING | 75 | 174 | 20 | test | 800 | 0 | 2011-09-29 00:00:00 | 80 | test | test | 40815_6
WAITING | 76 | 175 | 20 | test | 5 | 0 | 2011-09-29 00:00:00 | 0.5 | test | test | 40815_7
WAITING | 77 | 176 | 20 | test | 800 | 0 | 2011-09-29 00:00:00 | 80 | test | test | 40815_8
WAITING | 78 | 177 | 20 | test | 1 | 0 | 2011-09-29 00:00:00 | 0.1 | test | test | 40815_9
WAITING | 79 | 178 | 20 | test | 100 | 0 | 2011-09-29 00:00:00 | 20 | test | test | 40815_10
WAITING | 80 | 179 | 10 | test | 6 | 0 | 2011-09-29 00:00:00 | 0.3 | test | test | 40815_11
WAITING | 81 | 180 | 20 | test | 20 | 0 | 2011-09-30 00:00:00 | 2.5 | test | test | 40816_1
WAITING | 82 | 181 | 20 | test | 25 | 0 | 2011-09-30 00:00:00 | 2.5 | test | test | 40816_2
WAITING | 83 | 182 | 20 | test | 20 | 0 | 2011-09-30 00:00:00 | 2 | test | test | 40816_3
WAITING | 84 | 183 | 20 | test | 25 | 0 | 2011-09-30 00:00:00 | 2.5 | test | test | 40816_4
WAITING | 85 | 184 | 10 | test | 7 | 0 | 2011-10-03 00:00:00 | 0.7 | test | test | 40819_1
WAITING | 86 | 185 | 10 | test | 11 | 0 | 2011-10-03 00:00:00 | 1.1 | test | test | 40819_2
WAITING | 87 | 186 | 10 | test | 25 | 0 | 2011-10-03 00:00:00 | 2.5 | test | test | 40819_3
WAITING | 88 | 187 | 10 | test | 10 | 0 | 2011-10-03 00:00:00 | 1.43 | test | test | 40819_4
WAITING | 89 | 188 | 10 | test | 5 | 0 | 2011-10-03 00:00:00 | 0.71 | test | test | 40819_5
WAITING | 90 | 189 | 10 | test | 23 | 0 | 2011-10-03 00:00:00 | 3.84 | test | test | 40819_6
WAITING | 91 | 190 | 10 | test | 2 | 0 | 2011-10-03 00:00:00 | 0.33 | test | test | 40819_7
WAITING | 92 | 191 | 10 | test | 14 | 0 | 2011-10-03 00:00:00 | 2.8 | test | test | 40819_8
WAITING | 93 | 192 | 10 | test | 2 | 0 | 2011-10-03 00:00:00 | 0.4 | test | test | 40819_9
WAITING | 94 | 193 | 10 | test | 5 | 0 | 2011-10-03 00:00:00 | 1 | test | test | 40819_10
WAITING | 95 | 194 | 10 | test | 20 | 0 | 2011-10-03 00:00:00 | 1 | test | test | 40819_11
WAITING | 96 | 195 | 10 | test | 20 | 0 | 2011-10-03 00:00:00 | 1 | test | test | 40819_12
WAITING | 97 | 196 | 10 | test | 15 | 0 | 2011-10-03 00:00:00 | 0.75 | test | test | 40819_13
WAITING | 98 | 197 | 10 | test | 2 | 0 | 2011-10-03 00:00:00 | 0.1 | test | test | 40819_14
WAITING | 99 | 198 | 20 | test | 5 | 0 | 2011-10-04 00:00:00 | 0.5 | test | test | 40820_1
WAITING | 100 | 199 | 20 | test | 10 | 0 | 2011-10-04 00:00:00 | 1 | test | test | 40820_2
WAITING | 101 | 200 | 20 | test | 10 | 0 | 2011-10-04 00:00:00 | 1 | test | test | 40820_3
WAITING | 102 | 201 | 20 | test | 3 | 0 | 2011-10-04 00:00:00 | 0.6 | test | test | 40820_4
WAITING | 103 | 202 | 10 | test | 500 | 0 | 2011-10-14 00:00:00 | 16.65 | test | test | 40830_1
WAITING | 104 | 203 | 10 | test | 6 | 0 | 2011-10-18 00:00:00 | 0.3 | test | test | 40834_1
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0
 |  |  |  |  |  |  |  |  |  |  | _0