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-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.