Spreadsheet: 90972d1290648273-extract-the-latest-date-given-a-certain-parameter-flight-tracker-copy
Sheet: Sheet1

LEWIS |  |  |  |  |  |  |  | Last NVS | Days NVS | Last NVG | Days NVG |  |  |  |  |  |  |  |  |  |  |  |  |  | Today | A/C | Duty | Seat
 |  |  |  |  |  |  |  |  |  | 2010-11-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 290 | PI | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 298 | PC | F
 |  |  |  |  |  |  | Total | NVS | AH-64D | COMBAT | NVG |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 318
 |  |  |  |  | Hours from last 759 |  | 828.9 | 153.8 | 710.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 341
 |  |  |  |  | Current Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 354
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 364
 |  | F/S | B/S | Day | Night | NVS | Hood/WX | NVG | Total A/C | LCT F/S | LCT B/S | LCT Total |  |  |  |  |  |  |  |  |  |  |  |  |  | 391
 | Total Required | 15 | 15 |  | 2 |  | 3 |  | 70 | 4.5 | 4.5 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  | 398
 | Flown | 38.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other
 | Remaining | 0
Date | Crew Member | Seat | Duty | Day | Night | NVS | Hood | NVG | Total | A/C | LCT | LCT H / WX | LCT NS
2010-06-07 00:00:00 | RICHARDS | B | PI | 2.5 |  |  |  |  | 2.5 | Other | <-578
2010-06-30 00:00:00 | BREIDENSTEIN | B | PI | 1.2 |  | 2 |  |  | 3.2 | Other | <-039
2010-07-26 00:00:00 | [NAME] | B | PC |  |  |  |  |  |  |  | 1.5
2010-07-27 00:00:00 | BREIDENSTEIN | F | PI | 0.5 |  |  |  | 1 | 1.5 | Other | <-588
2010-08-02 00:00:00 | [NAME] | B | PC | 2 |  |  |  |  | 2 | Other | <-582
2010-08-04 00:00:00 | STEPHENS | B | PC |  |  | 1 |  | 1 | 2 | Other | <-039
2010-08-05 00:00:00 | SIMERLY | B | PC | 2.2 |  |  |  |  | 2.2 | Other | <-582
2010-08-10 00:00:00 | STEPHENS | B | PC | 2 |  |  |  |  | 2 | Other | <-588
2010-08-11 00:00:00 | STEPHENS | B | PC | 2 |  |  |  |  | 2 | Other | <-588
2010-08-13 00:00:00 | STEPHENS | B | PC |  |  | 2.5 |  |  | 2.5 | Other | <-588
2010-08-16 00:00:00 | SIMERLY | B | PC | 1.6 | 0.5 |  |  |  | 2.1 | Other | <-590
2010-08-17 00:00:00 | [NAME] | B | PC | 1 |  | 1 |  |  | 2 | Other | <-588
2010-08-19 00:00:00 | [NAME] | B | PC | 1.5 |  |  |  |  | 1.5 | Other | <-039
2010-09-07 00:00:00 | HARRIS | B | PC | 0.5 |  | 1 |  |  | 1.5 | Other | <-588
2010-09-14 00:00:00 | MAURO | B | PI | 0.5 |  |  |  |  | 0.5 | Other | <-041
2010-09-15 00:00:00 | [NAME] | B | PC |  |  | 1 |  | 1 | 2 | Other | <-041
2010-09-21 00:00:00 | STEPHENS | F | PC |  |  | 1 |  | 1 | 2 | Other | <-039
2010-10-28 00:00:00 | WORKS | F | PI | 0.5 |  | 1.1 | 0.3 |  | 1.9 | 364
2010-10-30 00:00:00 | MULLER | F | PI | 5.4 |  |  |  |  | 5.4 | 398
2010-10-31 00:00:00 | SENEFELD | F | PI | 2 |  | 2 |  |  | 4 | 298
2010-11-03 00:00:00 | SWYRYN | F | PI | 0.5 |  | 4.3 |  | 1 | 5.8 | 354
2010-11-05 00:00:00 | MARCEAUX | F | PI |  |  | 6.6 |  |  | 6.6 | 398
2010-11-07 00:00:00 | AYERS | B | PC |  |  | 0.5 |  |  | 0.5 | 298
2010-11-07 00:00:00 | AYERS | B | PC |  |  | 4 |  |  | 4 | 398
2010-11-09 00:00:00 | STEPHENS | B | PC |  |  | 4.2 |  |  | 4.2 | 341
2010-11-10 00:00:00 | MARCEAUX | F | PI |  | 2 | 2.3 |  |  | 4.3 | 341
2010-11-12 00:00:00 | STEPHENS | B | PC |  |  | 4 |  |  | 4 | 318
2010-11-13 00:00:00 | STEPHENS | B | PC | 1 |  | 6.5 |  |  | 7.5 | 341
2010-11-15 00:00:00 | STEPHENS | B | PC |  |  | 3.6 |  |  | 3.6 | 290
2010-11-16 00:00:00 | TRIVETTE | B | PC |  |  | 4.1 |  |  | 4.1 | 354
2010-11-16 00:00:00 | TRIVETTE | B | PC |  |  | 2.4 |  |  | 2.4 | 398
2010-11-18 00:00:00 | STEPHENS | B | PC |  |  | 4.3 |  |  | 4.3 | 354
2010-11-19 00:00:00 | MARCEAUX | F | PI |  |  | 2 |  | 2 | 4 | 391
2010-11-21 00:00:00 | OKPALA | B | PC | 1.2 |  | 3.5 |  |  | 4.7 | 318
2010-11-22 00:00:00 | MARCEAUX | B | PC |  |  | 4.3 |  |  | 4.3 | 391
2010-11-24 00:00:00 | TRIVETTE | F | PI |  |  | 2.4 |  | 1 | 3.4 | 391