topic Re: Format Date in QlikView

Format Date

Anonymous — Mon, 21 Mar 2016 15:48:07 GMT

Hello,

I would change the format of my ASOF table and put it in 'DD / MM / YY'. I tried to add in the table the expression "Date(ASOF, 'DD/MM/YY')" but just a column is added.

Thank you in advance for your help.

Cocalero

Re: Format Date

sunny_talwar — Mon, 21 Mar 2016 16:17:15 GMT

The image seems like a list box object? Try this expression

Date(Only({<ASOF>} ASOF), 'DD/MM/YY')

or you can change the format for AsOf on the Number tab by selecting Date on that tab

Re: Format Date

Chanty4u — Mon, 21 Mar 2016 16:19:53 GMT

chk dis

Why don’t my dates work?

Re: Format Date

Anonymous — Mon, 21 Mar 2016 16:21:32 GMT

Thanks a lot !