topic Issue with Date Format in App Development

Issue with Date Format

pallavi_96 — Thu, 14 Dec 2023 11:56:39 GMT

The date field in Excel displays a timestamp when it is extracted, but the Qlik Sense app displays the date format (DD-MMM-YYYY)

md_talib — Thu, 14 Dec 2023 12:42:25 GMT

Use this to display the format according to your requirement.

if your date format is 20231201 and you want to show in 01/12/2023.

Use this

Date(Date#(PostingDate,'YYYYMMDD'),'DD/MM/YYYY') As PostingDate.

pallavi_96 — Thu, 14 Dec 2023 13:09:22 GMT

Thank you for your response.

However, I'm curious as to why the timestamp is not visible in Qliksense app although it is visible when we extract the same column in Excel.

sergio0592 — Fri, 15 Dec 2023 13:04:08 GMT

And have you tried with Timestamp# function ?