1 Reply Latest reply on Feb 26, 2016 6:03 PM by Rachael Otto

    Date Format Conversion Issue

    saikaruna.nimmala

      I have a dimension named 'Report Period' in the format of "10-APR-15 to 10-MAY-15". I want the output in the format of "10/4/2015 - 10/5/2015". Can someone please tell me how to change it?

       

      Thanks,

      Sai.

        • 1. Re: Date Format Conversion Issue
          Rachael Otto

          Hey Saikaruna,

           

          Can you give me more background info on the desired result? Does the field Report Period have more than one record in the format "DD-MMM-YY to DD-MMM-YY"?

           

          What is the purpose of Report Period? Should this field function as a date field?

           

          Tableau Desktop does not easily work with date fields for which the individual records are ranges of dates, rather than individual dates. To easily convert the format in Tableau Desktop, it would be useful to know the intended end purpose for Report Period.

           

          Thanks!

          Rachael