Two Digit Date Problem

This is the problem with 2 digit years Anonymous 

You can try this custom column formula. Leave those dates as text, and create this column:

let
     varYear = Number.From(Text.AfterDelimiter([Date], "/", 1))
in
Date.From(
     Text.BeforeDelimiter([Date], "/", 1) 
     & "/" 
     & Text.From(
          (if varYear > 20 then 1900 else 2000) + varYear)
     )

Any date after 20 will be counted as the year 2000 or later, but that could be wrong. You can change it. But this logic will not allow you to have a 107 year old and a 7 yr old at the same time. 1/1/15 - is that 1915 or 2015? But depending you your data you can make that decision. Patients would be difficult for a hospital as they could have both, but employees would never have a 7yr old so you could adjust accordingly. Of course, not too many 107 yr old employees either. 😁

Then remove your orginal Date column