Nominal to date - cannot pearse as date columns in wrong format

TitzaaaTitzaaa Member Posts: 12 Learner I
edited July 2019 in Help
Hi everyone,

I would need some help with my nominal to date conversion: I try to merge to columns, one with the month and one with the year, into one date column.
It should then look something like this:
So I use the Generate attributes operator to receive only one attribute (out of one column containing the month, so the numbers 1-12, and one column containing the year, so numbers 2007-2019) and then try to format it as a date.

I get the following error message:

"Cannot pearse the date in line 1 for attribute Datum_Total with the date format dd.MM.yyyy. Unpearsable date:

So it seems the month and the year are somehow formatted the wrong way. Can you help me with this?


Best Answer

Sign In or Register to comment.