Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance during the next 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!

Date time conversion to MM


Hello All,


i have a dataset which has last updated, Date Time. I want to convert that field into minutes. How should I do that?

I have attached a sample dataset to this question

Help is highly appreciated

Alteryx Partner
a little confused about what you’re trying to convert to minutes, could you give an example?

Here is another sample dataset attached. 


So whenever someone comments on a particular task it shows the date and time (last updated) on that particular task. All the fields are in chronological order. I want to see after how many hours or minutes does another user comment on the same task, using the Last updated field  

Alteryx Partner

Hi @Arnsen,


You would be wanting to do a DateTimeDiff() function in a multi row formula in that case.




If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.