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?