Text to date datatype

[Marjan685]

 here i have the date column coming like this. I need to convert it into proper date type. How can I achieve this

[v-sgandrathi]

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.

[v-tejrama]

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.

[v-tejrama]

Hi @Marjan685 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you,
Tejaswi.

[FreemanZ]

hi @Marjan685 ,

I have some difficulties to relate your data with date, e.g. what is the corresponding date for "42:00.0" ?

[Omid_Motamedise · Accepted solution]

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])

[Marjan685]

If it is time, how it comes like 56:00.0

[Deku]

Don't think it can, but also not sure how it can be a date. What is the source system, what is the data type and format?

[Marjan685]

Currently it is a text type and basically the data is a damages data for the different shipments

[Deku]

That just looks like time. Is that what it looks in the source and have any transformations occured on the column?

[Marjan685]

If its time, how it comes pike 56:00.0