Forum Discussion

Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

In Power Query date between the years 1900 and 9999 are supported. 

The error says that there is a date 1/1/0099 which is naturally before year 1900, hence not supported. Hence, the operation is failing.

Either you need to correct this data in source or in Power Query itself.

ronrsnfld's avatar
ronrsnfld
Icon for Super User rankSuper 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
      Icon for Super User rankSuper User
      2 years ago

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