Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

How to get Date, hours and minutes difference

Belletmns
8 - Asteroid

Hi All,

 

What formula should I use to get the date, hours and minutes difference in Alteryx?

 

Belletmns_0-1603437853723.png

 

Duration should appear like this:

Belletmns_1-1603437889718.png

 

Thanks in advance!

3 REPLIES 3
grazitti_sapna
17 - Castor

Hi @Belletmns , could you provide some data with sample output?

I have prepared a mock workflow, just need to validate it.

 

grazitti_sapna_0-1603441106198.png

 

 

Thanks.

Sapna Gupta
RolandSchubert
16 - Nebula
16 - Nebula

Hi @Belletmns ,

 

it needs a bit of DateTime calculation.

 

I've attached a sample workflow. Let me know if it works for you.

 

Best,

 

Roland

Belletmns
8 - Asteroid

It works! Thank you so much

Labels