date to integer / integer to date problem (german dates) / 7 and 8 digits

[Anonymous]

Hey guys,

I am 99% sure that my question has already been asked several times, but I can't find a forum post with exactly my situation.

Today I imported a table from Excel which contained birthdays of people. These were according to the dd/mm/yyyy format (Germany). However, Power BI took these as integers and added some bugs.
For example, 07.07.1997 becomes 7071997 and 15.15.1995 becomes 15151995.

The problem is that there are birthdays with 7 and some with 8 digits (if the first digit is a 0 it will be removed). Therefore I cannot split the column to create a new birthday column.

Does anyone have a tip or an idea?

Many thanks and best regards

[ZunzunUOC · Accepted solution]

Have you look at Data Type? You must choose Date Type-> Date/Time and Format->dd.mm.yyyy

Best Regards,
Miguel

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

that does not work. It throws just ERROR:

beforeafterwards