Forum Discussion
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])
10 Replies
That just looks like time. Is that what it looks in the source and have any transformations occured on the column?
If its time, how it comes pike 56:00.0
If it is time, how it comes like 56:00.0
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])Hi Marjan685,
Has your issue been resolved?If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.
Thank you for your understanding!
Thank you and continue using Microsoft Fabric Community Forum.
Hi Marjan685,
Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If you've already resolved the issue, you can mark the helpful reply as a "solution" so others know that the question has been answered and help other people in the community. Thank you again for your cooperation!
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you,
Tejaswi.
