topic Re: Extracted Dates shouldn't include '00:00:00' in App Development

Extracted Dates shouldn't include '00:00:00'

Christian7 — Mon, 20 Mar 2023 14:04:34 GMT

I haven't used the timestamp function anywhere in the loading script.

When I copy a cell value in Qlik and paste it manually into Excel, it's correct. For example, '31/12/2022'.

However when I extract the entire table and open it up in Excel, that date now appears as '01/01/2023', and this is because the full item on the Excel file is '31/12/2022 00:00:00'.

How do I get rid of that '00:00:00'?

Re: Extracted Dates shouldn't include '00:00:00'

Or — Mon, 20 Mar 2023 14:10:19 GMT

You can explicitly format a date using e.g. date(Floor(YourField),'DD/MM/YYYY') as YourField.

Note that there is no difference between 31/12/2022 00:00:00 and 31/12/2022 and neither of them will evaluate to 01/01/2023.

Re: Extracted Dates shouldn't include '00:00:00'

Christian7 — Mon, 27 Mar 2023 07:51:54 GMT

Finally got back to this today, and it worked, thanks for you help with this Or.