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 · Accepted solution]

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

[RichardAlt]

It works! Thank you @Jonathan-Sherman , I added + 1 to the end of the formula because I'm getting 72 instead of 73. Anyway thank you again!