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. 

[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. 

[Luke_C]

You'd use the same formula, just update the field.

The syntax is datetimediff(date1, date2, units). So:

DateTimeDiff(DateTimeToday(),[SCAN DATE], "days")

Scan date looks to be in the correct format so no date parsing is needed

[JacobGFMR]

I am getting this error:

[Luke_C]

@JacobGFMR you need to name the new column. You can do so in the top left where it says "select column"

[ken_yap_au]

You need to give the field a name in the [Select Column] drop down. 

[Luke_C · Accepted solution]

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