Objective
- Reports Hub / data export downloads should show every time-based column in the company’s instance time zone (e.g. Eastern for an Eastern-configured org), not a mismatched offset that forces spreadsheet math.
Background
- SE request: exports were observed “not in Eastern or Central” when users expected local business time.
- Company default TZ lives on
attik-backend/src/models/companySchema.ts(timezone, defaultAmerica/Denver). - Generation flows through
src/routes/dataExport.tswith cell formatting insrc/util/functions/dataExports/formatting.ts(formatValue, etc.) and field metadata fromsrc/config/exportFieldDefinitions.ts.
Scope
Backend (attik-backend)
- Audit datetime serialization paths for CSV/XLSX (
generateCSV.ts,generateXLSX.ts) soformatValuereceives TZ context resolved from the exporting company. - Sweep all datetime-like fields in exports—including linked-entity columns formatted post-join.
Frontend (attik-frontend)
- Preview/download UX should label or inherit TZ consistently if previews are shown client-side (
src/app/tools/data-exports/).
References
attik-backend/src/routes/dataExport.tsattik-backend/src/util/functions/dataExports/formatting.tsattik-backend/src/models/companySchema.ts