Calculate difference of 2 dates

0 votes
Find the number of days difference between 2 date fields?
May 23 in Tableau by Priyanka
17 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes
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 4 by Sindhu

Related Questions In Tableau

0 votes
1 answer

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

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

answered Apr 11, 2018 in Tableau by QueenBee
• 1,810 points
13 views
0 votes
1 answer

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

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

answered Apr 11, 2018 in Tableau by xyz
• 1,550 points
378 views
0 votes
1 answer

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

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

answered May 8, 2018 in Tableau by Atul
• 5,510 points
80 views
+1 vote
1 answer

How can I calculate the % of completion

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

answered Jul 24, 2018 in Tableau by Atul
• 10,220 points
24 views
+1 vote
1 answer

How to calculate the number of hours worked in Tableau?

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

answered Aug 3, 2018 in Tableau by Atul
• 5,510 points
48 views
0 votes
1 answer

Need to display monthly data excluding 2 months of data

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

answered Mar 12 in Tableau by Cherukuri
• 15,820 points
36 views
+1 vote
1 answer

Date Logic in Tableau

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

answered Jul 26, 2018 in Tableau by Atul
• 5,510 points
32 views
0 votes
1 answer

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

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

answered Mar 27, 2018 in Tableau by Atul
• 10,220 points
1,171 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,220 points
38 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.