Excel-compatible timestamp formatting for rainfall results

3rww / rainfall

Search, visualize, and download real-time and historic hyper-local rainfall data in Allegheny County, PA

https://3rww.github.io/rainfall/

Apache License 2.0

4 stars 2 forks source link

Excel-compatible timestamp formatting for rainfall results #25

Open gassc opened 1 year ago

gassc commented 1 year ago

Currently, timestamps (including timezone offset) are returned using the RFC 3339 standard (ISO-8061 format). Excel doesn't automatically parse this out, requiring an extra step for end-users of the CSV download. We can return a spec that Excel will automatically parse.

gassc commented 5 days ago

Not sure what downstream is expecting ISO-8061 formattted datetimes. Need to investigate first.