Forum Discussion

ronrsnfld's avatar
ronrsnfld
Super User
2 years ago

In Power Query dates are supported from 1/1/0001. The problem lies elsewhere.

 

let
    Source = #table(1,{{"1/1/0099"},{"1/1/0001"}}),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}})
in
    #"Changed Type"

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Vijay,

Can you please explain briefly what is the issue?

Thanks

  • ronrsnfld's avatar
    ronrsnfld
    Super User
    2 years ago

    Not without seeing your data and code. And I'm not going to copy a screenshot.