table formatting is changed after the check mark on 'Table Formatting' while export the report

[K8859]

When i checked the "Table format", the date shown was not correct but  without checking the table formatting, the date shown properly. Did any has face this issue. I am using the August 2023 Patch 8-14.139.15

[Frank_S]

Please test with attached QVF.

Have tested with and without Table Formatting checkbox selected and it works normally.

However if your source data is not true date format, but rather text data ie: 43254. this could be resulting in the output inconsistency.

You can use the data load editor to update number dates to the expected output format.

See this help page for instructions:

https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/date-time-...

If you feel you have a defect (ie this has worked before where you've always had numeric source dates), please do start a support case.

Kind regards...