11 Replies Latest reply: Feb 1, 2017 5:42 PM by Ruben Marin RSS

    Format a Date field in a Straight Table

    Cliff Clayman

      I am trying to format a date field in a straight table and it is not taking the format.  Right now, the format looks like this in the straight table:

       

      1/31/2017 12:00:00 AM

       

      I want it to look like 1/31/2017

       

      I coded the Text Format expression for the Dimension field as such:

       

      =Date(Left([Posting Date],10),'MM/DD/YYYY')

       

      It does not change from the original format.  When I add a Text Object and put in the same code, the format changes as expected.  What is the issue with how I am doing it in the straight table?