Spreadsheet: 682483d1592137782-find-date-of-which-employee-satisfies-two-conditions-sample-2-3-
Sheet: NBD

1 | FLAG | ORDER-NO | DOC1 | DOC2 | NAME | PREM | PLAN | MODE | DOB | EM-CODE | DO | GC |  | COUNT | PREM
2 | XB | 354533573 | 20190425 | 4444444 | XXXXX | 100 | XXXXX | XXXXX | 19930401 | 192 | A0XX | Y |  | 1
3 | XB | 355025334 | 20190611 | 4444444 | XXXXX | 200 | XXXXX | XXXXX | 20180518 | 192 | A0XX | Y |  | 2
4 | XB | 355025533 | 20190624 | 4444444 | XXXXX | 300 | XXXXX | XXXXX | 20180511 | 192 | A0XX | Y |  | 3 |  | ELIGIBILITY DATE SHOULD BE 20190829(DATE ON WHICH BOTH CONDITIONS ARE SATISFIED)
5 | XB | 353033663 | 20190628 | 4444444 | XXXXX | 400 | XXXXX | XXXXX | 19800121 | 192 | A0XX | Y |  | 4 |  | (SATISFIES UNIQUE DOB ORDER CONDITION ON 20190828
6 | XB | 355040436 | 20190728 | 4444444 | XXXXX | 500 | XXXXX | XXXXX | 19800121 | 192 | A0XX | Y |  |  |  | BUT PREM>=50000 CONDITION WA SATISFIED ON 20190829)
7 | XB | 353452233 | 20190827 | 4444444 | XXXXX | 600 | XXXXX | XXXXX | 19870111 | 192 | A0XX | Y |  | 5
8 | XB | 353452300 | 20190828 | 4444444 | XXXXX | 700 | XXXXX | XXXXX | 19870110 | 192 | A0XX | Y |  | 6
9 | XB | 356553753 | 20190829 | 4444444 | XXXXX | 50000 | XXXXX | XXXXX | 19860120 | 192 | A0XX | Y |  | 7
10
11 | XB | 356554447 | 20191015 | 4444444 | XXXXX | 25000 | XXXXX | XXXXX | 19770601 | 727 | A0XX | Y |  | 1
12 | XB | 357657557 | 20191127 | 4444444 | XXXXX | 5317 | XXXXX | XXXXX | 19770602 | 727 | A0XX | Y |  | 2
13 | XB | 357657553 | 20191127 | 4444444 | XXXXX | 3915 | XXXXX | XXXXX | 20030810 | 727 | A0XX | Y |  | 3 |  | ELIGIBILITY DATE SHOULD BE 20200128(DATE ON WHICH BOTH CONDITIONS ARE SATISFIED)
14 | XB | 353452230 | 20200115 | 4444444 | XXXXX | 6533 | XXXXX | XXXXX | 19980911 | 727 | A0XX | Y |  | 4
15 | XB | 353452235 | 20200115 | 4444444 | XXXXX | 10991 | XXXXX | XXXXX | 19920626 | 727 | A0XX | Y |  | 5
16 | XB | 353452754 | 20200128 | 4444444 | XXXXX | 11637 | XXXXX | XXXXX | 19761201 | 727 | A0XX | Y |  | 6
17 | XB | 353452759 | 20200130 | 4444444 | XXXXX | 40000 | XXXXX | XXXXX | 19760601 | 727 | A0XX | Y |  | 7
18 | XB | 353033763 | 20200214 | 4444444 | XXXXX | 1937 | XXXXX | XXXXX | 19840601 | 727 | A0XX | Y |  | 8
19
20 | XB | 354533578 | 20190424 | 4444444 | XXXXX | 9923 | XXXXX | XXXXX | 19720605 | 888 | A0XX | Y |  | 1
21 | XB | 354533575 | 20190425 | 4444444 | XXXXX | 9923 | XXXXX | XXXXX | 19780601 | 888 | A0XX | Y
22 | XB | 354533579 | 20190429 | 4444444 | XXXXX | 9923 | XXXXX | XXXXX | 19780601 | 888 | A0XX | Y |  | 2 |  | ELIGIBILITY DATE SHOULD BE 20190528(DATE ON WHICH BOTH CONDITIONS ARE SATISFIED)
23 | XB | 355025036 | 20190522 | 4444444 | XXXXX | 500 | XXXXX | XXXXX | 19910101 | 888 | A0XX | Y |  | 3
24 | XB | 355025046 | 20190524 | 4444444 | XXXXX | 1091 | XXXXX | XXXXX | 19910501 | 888 | A0XX | Y |  | 4
25 | XB | 355025535 | 20190528 | 4444444 | XXXXX | 2673 | XXXXX | XXXXX | 19800704 | 888 | A0XX | Y |  | 5
26 | XB | 355025555 | 20190528 | 4444444 | XXXXX | 25000 | XXXXX | XXXXX | 19890101 | 888 | A0XX | Y |  | 6
27 | XB | 355025274 | 20190604 | 4444444 | XXXXX | 25000 | XXXXX | XXXXX | 19680101 | 888 | A0XX | Y |  | 7
28 | XB | 355025453 | 20190614 | 4444444 | XXXXX | 43758 | XXXXX | XXXXX | 19720601 | 888 | A0XX | Y
 | XB | 355040073 | 20190715 | 4444444 | XXXXX | 1313 | XXXXX | XXXXX | 19720601 | 888 | A0XX | Y
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1