Date Parsing from an Excel File Truncates the Century
earth2joy
Registered Posts: 1 ✭
Hi All,
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.
Thanks all for any ideas.
Joy
Answers
-
Sv3n-Sk4 Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 32 ✭✭✭✭
Hello @earth2joy
,
When does Dataiku is creating a problem by truncating wrongly the date ?When you are importing your xlsx file?