10 Replies Latest reply on Oct 26, 2018 3:47 AM by seraj alam

    Need help with a strange date format

    Jonathan Tunner

      I have a data set that is an index of CPI values dating back decades.  The values are monthly, but the dates are Jan-31, etc.  This stands for January of 1931, not January 31st.  Every time I try to custom edit the date format, I am unsuccessful.  I am hoping someone has a quick fix for this.  I am also using Tableau Prep, so advice on this front would be greatly appreciated in addition to desktop advice.  I have attached the data set.  As always, I am grateful for any help.  Jonathan