Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Date time conversion to MM

Arnsen
7 - Meteor

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

3 REPLIES 3
Jonathan-Sherman
15 - Aurora
15 - Aurora
a little confused about what you’re trying to convert to minutes, could you give an example?
Arnsen
7 - Meteor

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  

Jonathan-Sherman
15 - Aurora
15 - Aurora

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