Find the number of days difference between 2 date fields?
May 23, 2019 in Tableau 453 views

## 1 answer to this question.

Hi priyanka,

Use the datediff function to calculate difference in days or months or years.

Datediff('mode', start date field, end date field) here mode can be day, month or year.

DATEDIFF('day', [ORDER DATE], [SHIP DATE]) to get the difference.

Hope it helps.
answered Jun 5, 2019 by Sindhu

## Divide count of Table 1 by count of Table 2 on the same time interval

Use a custom SQL to create a ...READ MORE

## How can I calculate the median of sales price using 3 variables in Tableau

First let me clarify things for you. ...READ MORE

## How to calculate the percent of records within a group in tableau?

You can click the measure SUM(Number of Records) and ...READ MORE

+1 vote

## How can I calculate the % of completion

SUM(IIF([Status]="Delivered",[Point],NULL)) / SUM([Point]) I assume that your column ...READ MORE

+1 vote

## How to calculate the number of hours worked in Tableau?

Try using this LOD expression {fixed user : ...READ MORE

## Need to display monthly data excluding 2 months of data

Hi Anitha, 1. Drag and drop the respective year ...READ MORE

+1 vote

## Date Logic in Tableau

Try this: Create 2 calculated fields for start ...READ MORE

## How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE