Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'?
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.
Finally got back to this today, and it worked, thanks for you help with this Or.