Determining difference of days between arrival date and current date.

JacobGFMR

The answers provided to similar questions still create an error form.

The arrival date is provided (MM/DD/YYYY), and I need to know the difference between that date and the current date.

How to determine the difference in days between the arrival at queue date and the current date.

Help

Accepted answers

Luke_C

Also you do not need "datetimeparse(" in the formula.

All comments

Luke_C

Hi @JacobGFMR

You can use the datetime functions for this.

The below formula should work. It will take the difference of the two days. The datetimeparse is used to get the arrival date into the alteryx date format (yyyy-mm-dd).

DateTimeDiff(DateTimeToday(),datetimeparse([ARRIVAL AT QUEUE21],'%m/%d/%Y'), "days")

JacobGFMR

I apologize. I was working with an incorrect column.

I need to determine how many days from the current date this date is in this column.

Example:

How many days is 2021-03-23 from the current date.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703