How we calculate difference in Dates of the Row,

Question

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

flying008 · Answer

Hi, @rohit782192

Maybe this is your want ?

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

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

binu_acs · Answer

@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.

DateTime_0808.yxmd

Qiu · Answer

@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?