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