Forum Discussion

Marjan685's avatar
Marjan685
New Member
1 year ago
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
Need Help
  • Omid_Motamedise's avatar
    Omid_Motamedise
    1 year ago

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

v-sgandrathi's avatar
v-sgandrathi
Community Support
1 year ago

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's avatar
    v-tejrama
    Community Support
    1 year ago

    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's avatar
      v-tejrama
      Community Support
      1 year ago

      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.