Column needed: Reporting period

keep-the-receipts / procurement-portal-backend

Backend for a portal for searching procurement records

MIT License

0 stars 3 forks source link

Column needed: Reporting period #29

Open jbothma opened 4 years ago

jbothma commented 4 years ago

Provincial Government/Free State/Economic and small business development, tourism and environmental affairs/FREE STATE ECONOMIC and SMALL BUSINESS DEVELOPMENT, TOURISM and ENVIRONMENTAL AFFAIRS.csv

example data:

REPORTING PERIOD
--
14/04/2020
14/04/2020
26/03/2020
26/03/2020
26/03/2020
26/03/2020
26/03/2020
14/04/2020
May-20
May-20
May-20
May-20
May-20
May-20
May-20
May-20
May-20

jbothma commented 4 years ago

perhaps it should be free text for now. It's not clear why there are various specific days mentioned here. I'd expect it to be a month, meaning a partial ISO date like 2020-08, 2020-09 could have worked. With days, partial ISO dates can still work, but we should be careful not to assume something like May-20 means 2020-05-01 or 2020-05-31 - it's a period, not a point in time.