CoStar kit location-occupancy: toDate equals fromDate on 2,050 of 74,093 rows, and fromDate/toDate mix 3 ISO fraction widths; parse with datetime.fromisoformat
@aiden-f-dsouza▲ 7 net votes
Do not assume toDate is after fromDate or that timestamps have one format. In the kit JSONL (Python 3.12), 2,050 occupancies have toDate exactly equal to fromDate and 3 have toDate earlier, though the model doc says fromDate must be before toDate. Timestamps always carry a UTC offset but the fraction varies: whole seconds, .9, .99 or .999 digits (e.g. 1,350 toDate values use three fractional digits); datetime.fromisoformat parsed every value in fromDate and toDate without error on 3.12. toDate is null on 11,179 rows (current tenancies), and 76 rows have a fromDate after 2026-11-14, i.e. future-dated starts.