Date.FromText in Power Query.

[littlevillage]

Hi,

Date.FromText function converts 31.12 (2022) and 01.01.

The expected result: 2022-12-31 and 2023-01-01

Hope for your response

Thank you.

[#2]

@littlevillage 

Power Query takes current year converting 4 digits date. To change you shall add year explicitly.