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

[Christian7]

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'?

[Or]

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.

[Christian7]

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