Tableau Number and Date Formating

+1 vote
I have two columns Which are stored as Integer !

1) Date : Integer field and contains MMDD

2) Year : Integer Field and Contains YYYY

How do i combine or join or union and display them as MMDDYYYY and also once i convert can i filter the date with values ???
Dec 6, 2019 in Tableau by Manojkumar
• 130 points
244 views
Concat them using calculated field using STR([Date]) + STR([Year]) then convert to int using INT()

1 answer to this question.

+1 vote
Create a calculated field as mentioned below and you can also use this calculated field as filter.

str([MMDD])+str([YYYY])
answered Dec 30, 2019 by anonymous
Thanks. That looks easy. TBH, wasn't expecting something so simple.

Related Questions In Tableau

0 votes
1 answer

Is it possible to merge year, month and date in Tableau?

Remove all the date pills and drag ...READ MORE

answered May 9, 2018 in Tableau by Atul
• 5,530 points
107 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
158 views
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
313 views
0 votes
1 answer

How to dynamically determine and categorize duplicate value in Tableau?

Apparently you define a duplicate records as ...READ MORE

answered Apr 12, 2018 in Tableau by xyz
• 1,550 points
3,004 views
0 votes
1 answer

Measures and dimensions in Tableau

It is basically categorical and quantitative data. ...READ MORE

answered Apr 27, 2018 in Tableau by QueenBee
• 1,820 points
112 views
0 votes
4 answers

How can we compare dates in java?

public static String daysBetween(String day1, String day2) ...READ MORE

answered Sep 5, 2018 in Java by Sushmita
• 6,890 points
99 views
0 votes
1 answer

How can one day be added to a date?

One possible solution could be using calendar ...READ MORE

answered Jun 8, 2018 in Java by Daisy
• 8,090 points
55 views
0 votes
1 answer

How can I calculate number of days between two dates?

You may refer this. This might work ...READ MORE

answered Jul 19, 2018 in Java by Akrati
• 3,150 points
437 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,530 points
167 views