Forum Discussion
littlevillage
Jan 12, 2023Iron Contributor
Date.FromText in Power Query.
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.
SergeiBaklan
Jan 12, 2023Diamond Contributor
Power Query takes current year converting 4 digits date. To change you shall add year explicitly.