Days and Aging Formula

[geeklarokcmie]

Hello Experts,

I've been running into an error with aging and days using formula tool in Alteryx and need help with a resolution.

Input Data:

Issue Created

2024-03-26 14:32:26

2023-07-24 10:14:44

2023-10-03 12:51:04

2023-01-01 10:16:13

Expected Output:

Issue Created	Next Month	Days	Aging
3/26/2024 14:32	5/1/2024	36	31-60 Days
7/24/2023 10:14	5/1/2024	282	Exceeds 90 Days
10/3/2023 12:51	5/1/2024	211	Exceeds 90 Days
1/1/2023 10:16	5/1/2024	486	Exceeds 90 Days

[Bren_Spill]

@geeklarokcmie - something like the attached will get you there

[Sarreddy]

@geeklarokcmie  try it like this

[geeklarokcmie]

Thank you. That worked. :)

[Bren_Spill]

@geeklarokcmie @Sarreddy - this solution will only return aging buckets of 31-60 days or exceeds 90 days. Is that what you need? I factored buckets for 0-30 days and 61-90 days into my solution.

[geeklarokcmie]

I was able to modify the formula to capture all the days. I hope this helps. :)

IF [Days] <=30 THEN "1-30 Days"
ELSEIF [Days] <=60 THEN "31-60 Days"
ELSEIF [Days] <=90 THEN "61-90 Days"
ELSEIF [Days] >90 THEN "Exceeds 90 Days"
ELSE "Error"
ENDIF

[geeklarokcmie]

@Bren_Spill @Sarreddy I tried the formula provided with the actual data and I'm running into errors.

[Bren_Spill]

@geeklarokcmie - Created date is in the wrong format and needs to be converted to date time

[geeklarokcmie]

It still doesn't work. :(

[Bren_Spill · Accepted solution]

Put this in the custom section of the date time tool: %d/%b/%y