Spreadsheet: 767955d1644755518-matching-data-between-2-dates-sampledataset
Sheet: Enquiry

Unique ID | Date of Enquiry | Next Enquiry | Enq Number | No of Enqs
10344 | 2017-07-10 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
18043 | 2021-07-14 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
26401 | 2018-03-22 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
35847 | 2018-12-02 00:00:00 | 2019-11-04 00:00:00 | 1 | 2
35847 | 2019-11-04 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
43335 | 2017-05-10 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
74869 | 2019-02-14 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
76432 | 2019-05-14 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
85326 | 2018-01-26 00:00:00 | 2019-02-22 00:00:00 | 1 | 2
85326 | 2019-02-22 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
121358 | 2017-02-27 00:00:00 | 2017-08-24 00:00:00 | 1 | 2
121358 | 2017-08-24 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
121359 | 2017-02-27 00:00:00 | 2017-08-24 00:00:00 | 1 | 2
121359 | 2017-08-24 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
145575 | 2017-02-27 00:00:00 | 2017-08-24 00:00:00 | 1 | 2
145575 | 2017-08-24 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
155311 | 2021-02-11 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
159290 | 2019-06-05 00:00:00 | 2020-01-15 00:00:00 | 1 | 2
159290 | 2020-01-15 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
160521 | 2020-11-16 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
173040 | 2017-03-26 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
173041 | 2017-03-26 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
179125 | 2017-11-21 00:00:00 | 2020-08-18 00:00:00 | 1 | 2
179125 | 2020-08-18 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
179126 | 2017-11-21 00:00:00 | 2020-01-10 00:00:00 | 1 | 2
179126 | 2020-01-10 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
193666 | 2018-02-28 00:00:00 | 2021-12-07 00:00:00 | 1 | 2
193666 | 2021-12-07 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
197732 | 2017-11-21 00:00:00 | 2020-08-18 00:00:00 | 1 | 2
197732 | 2020-08-18 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
199832 | 2019-09-20 00:00:00 | 2019-10-28 00:00:00 | 1 | 2
199832 | 2019-10-28 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
206150 | 2018-10-16 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
216672 | 2019-10-18 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
231969 | 2021-07-14 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
234876 | 2019-06-05 00:00:00 | 2020-01-15 00:00:00 | 1 | 2
234876 | 2020-01-15 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
238691 | 2017-12-22 00:00:00 | 2018-06-26 00:00:00 | 1 | 3
238691 | 2018-06-26 00:00:00 | 2021-12-13 00:00:00 | 2 | 3
238691 | 2021-12-13 00:00:00 | 2100-12-31 00:00:00 | 3 | 3
238920 | 2019-06-05 00:00:00 | 2020-01-15 00:00:00 | 1 | 2
238920 | 2020-01-15 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
239535 | 2019-06-05 00:00:00 | 2020-01-15 00:00:00 | 1 | 2
239535 | 2020-01-15 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
243156 | 2021-12-16 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
243472 | 2021-12-16 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
245706 | 2017-04-21 00:00:00 | 2017-11-01 00:00:00 | 1 | 3
245706 | 2017-11-01 00:00:00 | 2018-03-09 00:00:00 | 2 | 3
245706 | 2018-03-09 00:00:00 | 2100-12-31 00:00:00 | 3 | 3
250067 | 2021-12-16 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
250862 | 2018-02-26 00:00:00 | 2019-06-05 00:00:00 | 1 | 2
250862 | 2019-06-05 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
307957 | 2018-03-25 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
315007 | 2018-07-26 00:00:00 | 2020-06-24 00:00:00 | 1 | 2
315007 | 2020-06-24 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
328715 | 2017-07-17 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
328743 | 2019-02-04 00:00:00 | 2020-06-22 00:00:00 | 1 | 3
328743 | 2020-06-22 00:00:00 | 2021-05-05 00:00:00 | 2 | 3
328743 | 2021-05-05 00:00:00 | 2100-12-31 00:00:00 | 3 | 3
329295 | 2019-10-18 00:00:00 | 2020-03-12 00:00:00 | 1 | 2
329295 | 2020-03-12 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
329296 | 2019-10-18 00:00:00 | 2020-03-12 00:00:00 | 1 | 2
329296 | 2020-03-12 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
329310 | 2019-01-08 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
329311 | 2019-01-08 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
1003042 | 2019-02-05 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
1003044 | 2019-06-14 00:00:00 | 2019-09-27 00:00:00 | 1 | 3
1003044 | 2019-09-27 00:00:00 | 2021-04-11 00:00:00 | 2 | 3
1003044 | 2021-04-11 00:00:00 | 2100-12-31 00:00:00 | 3 | 3
1003045 | 2019-06-14 00:00:00 | 2019-09-27 00:00:00 | 1 | 2
1003045 | 2019-09-27 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
1003134 | 2018-03-15 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
1003136 | 2018-01-19 00:00:00 | 2018-02-05 00:00:00 | 1 | 3
1003136 | 2018-02-05 00:00:00 | 2018-03-15 00:00:00 | 2 | 3
1003136 | 2018-03-15 00:00:00 | 2100-12-31 00:00:00 | 3 | 3
1003137 | 2017-03-24 00:00:00 | 2018-01-19 00:00:00 | 1 | 6
1003137 | 2018-01-19 00:00:00 | 2018-02-05 00:00:00 | 2 | 6
1003137 | 2018-02-05 00:00:00 | 2018-03-15 00:00:00 | 3 | 6
1003137 | 2018-03-15 00:00:00 | 2018-10-11 00:00:00 | 4 | 6
1003137 | 2018-10-11 00:00:00 | 2021-10-28 00:00:00 | 5 | 6
1003137 | 2021-10-28 00:00:00 | 2100-12-31 00:00:00 | 6 | 6
1003569 | 2018-07-20 00:00:00 | 2020-06-22 00:00:00 | 1 | 3
1003569 | 2020-06-22 00:00:00 | 2021-12-30 00:00:00 | 2 | 3
1003569 | 2021-12-30 00:00:00 | 2100-12-31 00:00:00 | 3 | 3
1003917 | 2018-03-28 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
1004053 | 2017-04-12 00:00:00 | 2018-04-25 00:00:00 | 1 | 4
1004053 | 2018-04-25 00:00:00 | 2020-01-15 00:00:00 | 2 | 4
1004053 | 2020-01-15 00:00:00 | 2021-11-08 00:00:00 | 3 | 4
1004053 | 2021-11-08 00:00:00 | 2100-12-31 00:00:00 | 4 | 4
1004320 | 2018-01-19 00:00:00 | 2018-03-19 00:00:00 | 1 | 2
1004320 | 2018-03-19 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
1004619 | 2017-04-12 00:00:00 | 2018-04-25 00:00:00 | 1 | 4
1004619 | 2018-04-25 00:00:00 | 2020-01-15 00:00:00 | 2 | 4
1004619 | 2020-01-15 00:00:00 | 2021-11-08 00:00:00 | 3 | 4
1004619 | 2021-11-08 00:00:00 | 2100-12-31 00:00:00 | 4 | 4
1005008 | 2021-09-15 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
1005255 | 2021-09-15 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
1005367 | 2019-03-01 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
1005415 | 2018-01-26 00:00:00 | 2018-09-12 00:00:00 | 1 | 3
1005415 | 2018-09-12 00:00:00 | 2018-11-28 00:00:00 | 2 | 3
1005415 | 2018-11-28 00:00:00 | 2100-12-31 00:00:00 | 3 | 3
1005416 | 2018-01-26 00:00:00 | 2018-09-12 00:00:00 | 1 | 3
1005416 | 2018-09-12 00:00:00 | 2018-11-28 00:00:00 | 2 | 3
1005416 | 2018-11-28 00:00:00 | 2100-12-31 00:00:00 | 3 | 3
1005837 | 2017-04-12 00:00:00 | 2018-04-25 00:00:00 | 1 | 4
1005837 | 2018-04-25 00:00:00 | 2020-01-15 00:00:00 | 2 | 4
1005837 | 2020-01-15 00:00:00 | 2021-11-08 00:00:00 | 3 | 4
1005837 | 2021-11-08 00:00:00 | 2100-12-31 00:00:00 | 4 | 4
1006152 | 2017-07-27 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
1008545 | 2020-10-02 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
1008616 | 2019-02-08 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
1008893 | 2016-09-27 00:00:00 | 2018-07-26 00:00:00 | 1 | 2
1008893 | 2018-07-26 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
1009493 | 2016-06-16 00:00:00 | 2016-09-28 00:00:00 | 1 | 2
1009493 | 2016-09-28 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
1009508 | 2018-09-17 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
1009509 | 2018-07-27 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
1009645 | 2017-09-11 00:00:00 | 2100-12-31 00:00:00 | 1 | 1
1009776 | 2017-06-05 00:00:00 | 2020-06-15 00:00:00 | 1 | 2
1009776 | 2020-06-15 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
1009847 | 2017-04-07 00:00:00 | 2017-06-29 00:00:00 | 1 | 2
1009847 | 2017-06-29 00:00:00 | 2100-12-31 00:00:00 | 2 | 2
1009848 | 2018-06-13 00:00:00 | 2019-07-12 00:00:00 | 1 | 2
1009848 | 2019-07-12 00:00:00 | 2100-12-31 00:00:00 | 2 | 2