Date Difference

As @aatalai said, group by option can be used, and now updated WF looks like this. Please do not forget to sort data by account & date to properly calculate the difference.

1240082_gawa_REV1.yxmd

All comments

Gawa

hi @Vapour02

In order to use DateTIme functions properly, we need to be sure of the field type being Date type.

Here is the example to convert input data into Date type, and then calculate difference in days my Multi Row Formula tool.

1240082_gawa.yxmd

Vapour02

Also I forgot to mention there can me multiple account numbers for different dates so how to define that difference.

For example.

Account number. Date

1234. 10/01/2022

1234. 10/10/2022

1245. 10/05/2022

1245. 10/08/2022

So I need to find the exact date difference for two dates for different accounts

aatalai

@Vapour02

Are you looking for the difference with the row above?

Then should be DateTimeDiff([date], [ dater:row-1],'days')

If that doesn't work, check the date time format is correct, i.e that alteryx is reading the date as mm/dd/yyyy

Let me know how you get on

aatalai

@Vapour02 in that case use the multi row tool and select group by account number

Vapour02

Thank you so much that worked. The only mistake I was doing is not grouping by the account number.

aatalai

@Vapour02 glad to have helped

Gawa

@Vapour02

As @aatalai said, group by option can be used, and now updated WF looks like this. Please do not forget to sort data by account & date to properly calculate the difference.

1240082_gawa_REV1.yxmd

Vapour02

@gawa thanks a lot this way worked as well. Much appreciated for all the help

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703