Tableau Number and Date Formating

Question

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 ???

Comments

Concat them using calculated field using STR([Date]) + STR([Year]) then convert to int using INT()

Answer 1

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

str([MMDD])+str([YYYY])

Comments

Thanks. That looks easy. TBH, wasn't expecting something so simple.