From the course: Complete Guide to Tableau for Data Scientists

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Manipulating dates with date functions

Manipulating dates with date functions - Tableau Tutorial

From the course: Complete Guide to Tableau for Data Scientists

Start my 1-month free trial Buy for my team

Manipulating dates with date functions

“

- [Instructor] Tableau makes it really easy to manipulate dates, and we're going to look at a couple of the functions now, one for adding duration to dates and one to create durations based off of dates so we can look for the amount of time that's elapsed between two different dates. And to do that, I'm going to first create a table so I can see the results of the calculation in real time. So we have orders in our system, and we have an order date, and we have a shipping date, so I'm going to build a quick table with the order ID, and I want the order date, so I'm going to right-click or hold down the Option button when I do my left-click drag for a Mac. I'm going to select the second order date, Order Date Discrete, so I can see the numeric value of that order date. Do the same thing again with ship date, right-click or Option + left mouse drag for Mac, and we'll do our shipping date. So the first function I'm going to use is DateAdd. This allows us to add an amount of time onto an…

Contents