Hello all, I need help to find the date difference in days between two dates which are in same column.
Example:
Date:
10/01/2022
10/09/2022
11/15/2022
11/25/2022
I tried the multi row formula but it gives the wrong output when the month changes.
Please help with the solution.
Solved! Go to Solution.
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.
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
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
@Vapour02 in that case use the multi row tool and select group by account number
Thank you so much that worked. The only mistake I was doing is not grouping by the account number.
@Vapour02 glad to have helped :)
@gawa thanks a lot this way worked as well. Much appreciated for all the help