4 Replies Latest reply on Nov 4, 2016 7:43 AM by Mark Fagan

    Format date field from yyyymmdd to mmddyyyy in calculated field as string

    Mark Fagan

      I have a calculated field that is:

        "- " +str([Name (Exceptions)]) + " has an exception of " + str([DisplayValue Adjusted]) + " from W/E " + str([Start Date Weekending]) + " through " + str([End DateWeek Ending])

       

      The last part of the calc field is:

        str([Start Date Weekending]) + " through" + str([End Date Week Ending])

       

      Returns this:  

      2016-07-31  through 2016-11-19

       

      I want the result to show this:

      7/31/2016 through 11/19/2016

       

      How can I make this happen? The date as a stand-alone pill is fine, it's the string that changes it...

       

      Thank you,

       

      Mark