Date Parsing from an Excel File Truncates the Century
I have an .xlsx input with a field full of future dates (e.g. 3/8/2053). I was having an issue with DataIku truncating the century (e.g. 3/8/53), then parsing it into the previous century (e.g. 1953-03-08...). I managed to fix the issue by reformatting the Excel file date field to show a full date-time (e.g. yyyy-mm-dd hh:MM:ss), but I can't expect the end user to reformat his input file every time - the process runs daily.
I suppose I could add 100 years, but that might be tricky, too, if a 2024 date, for example, parses correctly.