Closed tmcelrath closed 3 months ago
There are a series of loans with bad dates, they include:
taxonworks_development=# select id, date_requested, date_sent from loans where date_sent < date_requested and project_id = 1; id | date_requested | date_sent ------+----------------+------------ 41 | 1966-05-22 | 1961-10-19 76 | 1981-04-12 | 1981-03-30 77 | 1975-08-20 | 1975-08-05 244 | 1990-12-06 | 1990-01-25 423 | 1999-05-24 | 1999-05-01 496 | 2010-05-21 | 2010-05-20 928 | 2007-11-26 | 2007-11-19 1083 | 1996-06-24 | 1969-06-24 1241 | 1988-08-19 | 1987-08-19 1677 | 1975-05-26 | 1971-05-01 1761 | 1999-03-11 | 1999-02-17 1756 | 2000-05-18 | 2000-01-15 1790 | 1999-12-19 | 1999-01-05 1930 | 1995-04-20 | 1995-03-17 2006 | 1999-01-14 | 1998-12-11 2019 | 1999-05-06 | 1999-05-05 2060 | 1958-05-26 | 1957-11-01 2116 | 1969-09-09 | 1966-06-20 2375 | 1984-03-29 | 1984-03-28 2457 | 1933-10-28 | 1933-10-26 2459 | 1929-04-15 | 1929-04-11 2706 | 1961-05-09 | 1960-05-09 3117 | 2016-03-21 | 2016-03-18 2026 | 1999-08-10 | 1999-08-09 1079 | 1997-08-09 | 1997-08-08 1282 | 1989-11-21 | 1989-10-30
Perhaps we can consult original documentation to fix these.
[x] You can also do a date-range search for each of the date related fields to look for dates prior to the earliest cutoff. There are at least 1 or two very old (16xx) dates to be fixed.
[x] 41 | 1966-05-22 | 1961-10-19
[x] 76 | 1981-04-12 | 1981-03-30
[x] 77 | 1975-08-20 | 1975-08-05
[x] 244 | 1990-12-06 | 1990-01-25
[x] 423 | 1999-05-24 | 1999-05-01
[x] 496 | 2010-05-21 | 2010-05-20
[x] 928 | 2007-11-26 | 2007-11-19
[x] 1083 | 1996-06-24 | 1969-06-24
[x] 1241 | 1988-08-19 | 1987-08-19
[x] 1677 | 1975-05-26 | 1971-05-01
[x] 1761 | 1999-03-11 | 1999-02-17
[x] 1756 | 2000-05-18 | 2000-01-15
[x] 1790 | 1999-12-19 | 1999-01-05
[x] 1930 | 1995-04-20 | 1995-03-17
[x] 2006 | 1999-01-14 | 1998-12-11
[x] 2019 | 1999-05-06 | 1999-05-05
[x] 2060 | 1958-05-26 | 1957-11-01
[x] 2116 | 1969-09-09 | 1966-06-20
[x] 2375 | 1984-03-29 | 1984-03-28
[x] 2457 | 1933-10-28 | 1933-10-26
[x] 2459 | 1929-04-15 | 1929-04-11
[x] 2706 | 1961-05-09 | 1960-05-09
[x] 3117 | 2016-03-21 | 2016-03-18
[x] 2026 | 1999-08-10 | 1999-08-09
[x] 1079 | 1997-08-09 | 1997-08-08
[x] 1282 | 1989-11-21 | 1989-10-30
Fixed by @tmcelrath manually
There are a series of loans with bad dates, they include:
Perhaps we can consult original documentation to fix these.
[x] You can also do a date-range search for each of the date related fields to look for dates prior to the earliest cutoff. There are at least 1 or two very old (16xx) dates to be fixed.
[x] 41 | 1966-05-22 | 1961-10-19
[x] 76 | 1981-04-12 | 1981-03-30
[x] 77 | 1975-08-20 | 1975-08-05
[x] 244 | 1990-12-06 | 1990-01-25
[x] 423 | 1999-05-24 | 1999-05-01
[x] 496 | 2010-05-21 | 2010-05-20
[x] 928 | 2007-11-26 | 2007-11-19
[x] 1083 | 1996-06-24 | 1969-06-24
[x] 1241 | 1988-08-19 | 1987-08-19
[x] 1677 | 1975-05-26 | 1971-05-01
[x] 1761 | 1999-03-11 | 1999-02-17
[x] 1756 | 2000-05-18 | 2000-01-15
[x] 1790 | 1999-12-19 | 1999-01-05
[x] 1930 | 1995-04-20 | 1995-03-17
[x] 2006 | 1999-01-14 | 1998-12-11
[x] 2019 | 1999-05-06 | 1999-05-05
[x] 2060 | 1958-05-26 | 1957-11-01
[x] 2116 | 1969-09-09 | 1966-06-20
[x] 2375 | 1984-03-29 | 1984-03-28
[x] 2457 | 1933-10-28 | 1933-10-26
[x] 2459 | 1929-04-15 | 1929-04-11
[x] 2706 | 1961-05-09 | 1960-05-09
[x] 3117 | 2016-03-21 | 2016-03-18
[x] 2026 | 1999-08-10 | 1999-08-09
[x] 1079 | 1997-08-09 | 1997-08-08
[x] 1282 | 1989-11-21 | 1989-10-30