I imported a CSV file that contains a column of dates without the year being specified. When I changed the format to Date, calc presumed the year to be 2026, whereas it needs to be 2025. How can I avoid this in the future? Fwiw, this time around I fixed it by subtracting the number of days in the year.
