Forum Discussion
Time Duration to Date Conversion
Hi Anonymous ,
Do you want to convert the field Duration to a date? But How did you get the duration field? Is the duration the duration from the creation time to a special day or some other date? For example, the last duration (21h 30m) is the duration from the creation date to today (28-06-2022 8:00:00) 21h 30m, so the last date value you want to get is 27-06-2022 11:30:00? Could you please give the duration, date field and your expected result with more explanation and screenshot? Thank you.
Best Regards
Hi Anonymous ,
Thanks for responding,
I got this duration field from my JIRA admin(as we are working with JIRA data in power BI) .
Yes, my request is to convert the duration column to date column( DD-MM-YYYY HH:MM:00) so that I can refer this duration column in a DATEDIFF funtion where I have a created date minus with this Duration column.
Actual formulae is- DATEDIFF ([created], [Candidate Offboarded]),
As candidate Offboarded is a duration column and created is a date column, I need to convert the Candidate Offboarded also into a date field so that my datediff will give me the the duration again as needed.
Sample Data:
Created Date
| 25-05-2022 13:26:00 |
Derived Date
| 3w 0d 22h 44m |
And yes as per my understanding what you referred is correct- the last duration (21h 30m) is the duration from the creation date to today (28-06-2022 8:00:00) 21h 30m, so the last date value you want to get is 27-06-2022 11:30:00?
Thanks, Please do let me know if any inputs required from myside as i am a new bee and might miss few things.