format date

[Woppi]

Hi, date is shown as 20211209. If I try to convert in number format "date" (DD.MM.YYYY), the date is displayed like this 28.05.57236.

[JHuis · Accepted solution]

Hi,

you have to convert it to a date:

Date(Date#(DATEVALUE,'YYYYMMDD'))

[Joseph_Musekura]

Hi @Woppi ,

As suggested by  @JHuis , check the difference between using date () and Date# here https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157

/joseph

[Woppi]

Perfect! Thank you