29
The same monthly CSV imports with half the dates as text and half silently swapped day and month — how do I stop guessing?
I get a CSV from someone else's system on the first of every month. The date column comes in as something like 03/07/2026. What happens on import is the worst possible outcome: some rows become real dates, some stay as…