Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Time Duration to Date Conversion

Hi ALL, New Bee here. I have a client request today to convert a Time Duration column to Date (As shown in the table). Can you experts please help me to achieve the exact date format with the code....
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , You can split it on power Query using split by delimiters. Then you can remove the text.

 

Then you add it date

date(2022,01,01) + [week]+7 + [Day] + Time([Hour], [Minute], 0)

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi amitchandak ,

 

Can you please advice with another solution, As I need to use this DATE column in a DATEDIFF (Example : Candidate dropout since = DATEDIFF( createdate,date)

where as date is the column which we i am trying to create now from the duration (shown in the above table).

 

Please help,

Thanks,Naveen