Forum Discussion
Date
I took a date in a Database with the year 18,19,20,21,22 and i load it but it came as decimal but when i try to convert these to Date it comes out as 1900 and i don't know how to get the right date. Thanks in advance for your upcoming solution
Here is the date but it is in decimal number but when i try to change it to date format it is giving me something else as shown below;
7 Replies
- wdx223_DanielCommunity Champion
=Table.TransformColumns(PreviousStepName,{"GJ",each #date(2022,12,_)})
- AnonymousNot applicable
wdx223_Daniel should i create a new colum and add this Syntax?
- AnonymousNot applicable
wdx223_Daniel your solution is not working or may be i am doing it wrongly
- wdx223_DanielCommunity Champion
replace PreviousStepName with your real step name, which is listed on the right pane
- AnonymousNot applicable
If you just need the 4 digit year, just click the "Addition" button and add 2000. If you are trying to get a date like 1/1/2019, etc. then try:
= Table.AddColumn(PriorStepOrTableName, "Year", each #date([GJ]+2000, 1, 1), type date)
--Nate
- AnonymousNot applicable
Anonymous it is not working. Can you please tell me where should i paste your Code? I am new in Power bi