Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

How we calculate difference in Dates of the Row,

rohit782192
11 - Bolide

DateDifference and Time 12-30-18 1:53 AM 12-30-18 2:08 AM 12-30-18 3:12 AM 12-30-18 3:27 AM 12-30-18 4:00 AM 12-30-18 4:15 AM 12-30-18 2:30 AM 12-30-18 2:45 AM 12-30-18 3:20 AM 12-30-18 3:35 AM 12-30-18 2:30 AM 12-30-18 2:45 AM 12-30-18 4:12 AM 12-30-18 4:27 AM 12-30-18 4:00 AM 12-30-18 4:15 AM 12-30-18 5:16 AM 12-30-18 5:31 AM 12-30-18 4:59 AM 12-30-18 5:14 AM

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@rohit782192 

We are happy to help.
but can you at least give clear description of your challenge?

In this case,

1. what would be the definition of of "Time difference"?

2, Data in structure, rathan then just a paragraph

3. What is the expected output?

binuacs
21 - Polaris

@rohit782192 one way of doing this, is first you need to convert the given date in the Alteryx DateTime format, then you need to use the DateDiff function to calculate the difference.

 

 

binuacs_0-1659945903932.png

 

flying008
15 - Aurora

Hi, @rohit782192 

 

Maybe this is your want ?

 

录制_2022_08_08_16_43_05_656.gif

 

If you follow datatime format-syntax as @binuacs , the formula tool of 2nd step is not need. 

%m-%d-%y %I:%M %p

  

Labels
Top Solution Authors