Get the difference between today's date and column date

RichardAlt

Hi guys,

I know this is already asked question, I've follow and checked the older question but I'm getting null values.

This is inside the formula tool

This is the column transaction date.

And this is the formula to excel, 

=ROUNDUP((NOW())-L2,0)

The output in the excel is 73 but in alteryx the output is null.

Any idea guys? Thanks!

Jonathan-Sherman

Hi @RichardAlt,

You'll want to use:

DateTimeDiff(DateTimeToday(),DateTimeParse([TransactionDate],'%m/%d/%Y'),"days")

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200429 - DateTimeParse.yxmd