DateDiff() function help - Dates in 2 different columns

datediff date-difference tableau-api
cg529d picture cg529d · May 20, 2015 · Viewed 33.9k times · Source

I am trying to write a function to enable Tableau to calculate the difference between 2 dates, however they are in 2 different columns and I am having a bit of trouble.

Example:

Column 1

First Opened Date - 10/01/2014

Column 2

Reviewed Date - 15/01/2014

Obviously from this example there is 5 days between the two different columns.

These columns are aligned in rows due to a unique ID.

Any help would be much appreciated!

Thanks Ellie

Answer

e h picture e h · May 20, 2015

I am not sure exactly what your data looks like, but you could calculate the difference in days between two dates by using the datediff function.

I am using this calculation: DATEDIFF('day',[Order Date],[Ship Date])

You can easily recreate this with the sample data set (superstore) that ships with tableau.

enter image description here

Related questions

Difference between two dates in dates using Google bigquery?

How can I get the difference in days between 2 timestamp fields in Google Big Query? The only function I know is Datediff which only works in Legacy SQL but I'm in Standard SQL. For example: the difference between 20180115 to 20180220 is 36 …

Read More
How to calculate the difference between two dates using PHP?

I have two dates of the form: Start Date: 2007-03-24 End Date: 2009-06-26 Now I need to find the difference between these two in the following form: 2 years, 3 months and 2 days How can I do this in PHP?

Read More
DATEDIFF function in Oracle

I need to use Oracle but DATEDIFF function doesn't work in Oracle DB. How to write the following code in Oracle? I saw some examples using INTERVAL or TRUNC. SELECT DATEDIFF ('2000-01-01','2000-01-02') AS …

Read More