How to calculate ageing between 2 dates

[MaheshR]

Dates:

14-06-20	09-06-20
14-06-20	09-06-20
14-06-20	09-06-20
14-06-20	09-06-20
14-06-20	09-06-20
14-06-20	08-06-20
14-06-20	08-06-20
14-06-20	08-06-20
14-06-20	08-06-20
14-06-20	08-06-20
14-06-20	08-06-20
14-06-20	08-06-20
14-06-20	08-06-20
14-06-20	08-06-20
14-06-20	08-06-20
14-06-20	08-06-20

[JosephSerpis]

Hi @MaheshR you need to use DateTimeFiff function however you will need to specify your dates in the format alteryx recognises which is YYYY-MM-DD. This link may be useful as it explains datetime functions in alteryx. I have mocked up a workflow let me know what you think?

[npeddagorla]

Hello @MaheshR ,

find the attached sample workflow.

Regards,

Naveen.

[echuong1 · Accepted solution]

You can use the datetimediff() function in the Formula tool to calculate the difference.

Before you can use the formula tool, you'll need to convert the dates to Alteryx recognized dates. You can use the datetimeparse tool to achieve this.

See attached for an example workflow.