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?

[cliff_clayman]

This doesn't work.  Also, I don't see where you rename and drop the field.

[rubenmarin]

I only copied that part, but the rest should be as it was in your previous post.

Anyway, keep the calculated dimension if it works.