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!
SOLVED

Date time conversion to MM

Meteoroid

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

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

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  

Highlighted
Alteryx Partner

Hi @Arnsen,

 

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

 

image.png

 

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.

 

Regards,

Jonathan

Labels