How can I convert week into Date(mm/dd/yyyy)?

0 votes

What I want?

Convert the week field into Date(mm/dd/yyyy).

Sample Dataset: Week 1 Week 2 Week 3 .........Week 22

What I did?

Dragged the date field into Columns and selected the week.

But I need to convert this into Date (mm/dd/yyyy).

Can someone tell me how can I achieve this?

Aug 9, 2018 in Tableau by ghost
• 1,790 points
152 views

1 answer to this question.

0 votes

Right click on your date field, you'll get a menu with the following options:

"Filter" , "Show quick filter", etc. You'll also see an option which says "Day.... May 8, 2011". That gives you a full date.

But if you want that date to have the "mm/dd/yyyy" format, you'll need to change it from the left pane. Right clicking on your date dimension provides the following option: "Default Properties/Date Format". You have a few default formats in there, including a custom formatting where you could make it mm/dd/yyyy.

answered Aug 9, 2018 by Atul
• 10,240 points

Related Questions In Tableau

0 votes
0 answers

How can I sort date field in presence of another date field in Tableau?

Goal: Sort the new ship date in ...READ MORE

Apr 10, 2018 in Tableau by ghost
• 1,790 points
145 views
+2 votes
1 answer
0 votes
1 answer

How can I use Tableau to create a heatmap?

Step 1: Create an Excel Spreadsheet with ...READ MORE

answered Apr 2, 2018 in Tableau by Atul
• 5,530 points
675 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
757 views
0 votes
1 answer

How to create a filter based on date range?

You can use this code snippet in ...READ MORE

answered Aug 7, 2018 in Tableau by Nitish
• 630 points
61 views
0 votes
1 answer

How to display days data based on date selected in the filter by the user.

You can create a parameter for dates. Select data ...READ MORE

answered Aug 14, 2018 in Tableau by AwesomeSauce
• 860 points
64 views
0 votes
1 answer

How to merge Year ,Month and date in Order Date in Tableau?

Hi, you can simply drag the Order ...READ MORE

answered Aug 24, 2018 in Tableau by AwesomeSauce
• 860 points
82 views
0 votes
1 answer

How to get only the last n months action of all my records?

Hi Nithin, You can use Calculated field to ...READ MORE

answered Mar 8 in Tableau by Cherukuri
• 28,360 points
54 views
0 votes
1 answer

How can I count the aggregate function in Tableau

Create two calculated fields one for 100's ...READ MORE

answered Apr 5, 2018 in Tableau by Atul
• 10,240 points
1,758 views
0 votes
1 answer

How can I use COUNTD function in Tableau?

First add Col1 to the Columns shelf. Then ...READ MORE

answered May 8, 2018 in Tableau by Atul
• 10,240 points
714 views