Could someone please, if possible, assist me in creating a workflow that shows the difference between the 'Created Date (UTC)' and 'Last Modified Date (UTC)' in the attached sheet.
As they are on the same day I would like the output to ignore the date and just show the time elapsed between the two figures in a new column(D).
Solved! Go to Solution.
Look at the DateTimeParse and DateTimeDiff functions
https://help.alteryx.com/current/Reference/Functions.htm
Hi @Brytsyt
If you want the difference in seconds, here's a way to do it.
Use a Formula Tool:
DateTimeDiff(DateTimeParse([Last Modified Date (UTC)],"%m/%d/%Y %H:%M"),
Replace(ReplaceChar([Created Date (UTC)], "T", " "), "Z", ""), "seconds")
Cheers,
Hi @Brytsyt ,
I've attached the workflow for you.
I've created the formula so it will tell you if the difference is in Days or Minutes.
I hope this helps.
M.
Thank you @mceleavey that works perfectly!!
Thank you for your help @Thableaus - much appreciated!!