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.
1 Reply
- SergeiBaklanDiamond Contributor
Power Query takes current year converting 4 digits date. To change you shall add year explicitly.