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 raj
• 130 points
1,018 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 31, 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 10, 2018 in Tableau by ffdfd
• 5,550 points
1,566 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
2,742 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
1,376 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 13, 2018 in Tableau by xyz
• 1,560 points
7,266 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
1,393 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,920 points
1,426 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,140 points
642 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,190 points
1,254 views
+1 vote
1 answer

Date Logic in Tableau

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

answered Jul 27, 2018 in Tableau by ffdfd
• 5,550 points
1,285 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP