Dates: 14-06-2009-06-2014-06-2009-06-2014-06-2009-06-2014-06-2009-06-2014-06-2009-06-2014-06-2008-06-2014-06-2008-06-2014-06-2008-06-2014-06-2008-06-2014-06-2008-06-2014-06-2008-06-2014-06-2008-06-2014-06-2008-06-2014-06-2008-06-2014-06-2008-06-2014-06-2008-06-20

How to calculate ageing between 2 dates

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

Accepted answers

echuong1

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.

sample (1).yxmd

All comments

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?

Datetimedff_15062020.yxmd

npeddagorla

Hello @MaheshR ,

find the attached sample workflow.

Regards,

Naveen.

Aeging.yxmd

echuong1

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.

sample (1).yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280