Format issue in straight table with Date?

[diane_yu]

Hello,

I'm new to a Qlikview and I'm having an issue with formatting date field. In list box, CLOSED_DATE column formats anyway I wanted but not with striahg table. Currently, it display like '42019.7131...'. When I change the format to

=date(closed_date,'mm/dd/yyyy') -> it displays like 07/15/2015.....52/15/2015...49/15/2015 and so forth...

In database, it is a datefield.

Thank you for your support in advance!

Di

[diane_yu]

You are so kind.  Thank you for the information.

Di