Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
cliff_clayman
Creator II
Creator II

Format a Date field in a Straight Table

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?

11 Replies
cliff_clayman
Creator II
Creator II
Author

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.