Forum Discussion
Solved
Text to date datatype
here i have the date column coming like this. I need to convert it into proper date type. How can I achieve this
Your values are in type duration, you can use the function Duration.From() and then add it to your base date, so add a new column and if your based date is 2025/1/1/, use the forlowing formula.
#date(2025,1,1)+Duration.From([column name])
Your values are in type duration, you can use the function Duration.From() and then add it to your base date, so add a new column and if your based date is 2025/1/1/, use the forlowing formula.
#date(2025,1,1)+Duration.From([column name])