topic Time stamp issues in Qlik NPrinting

Time stamp issues

Raju_6952 — Fri, 15 Nov 2024 21:07:53 GMT

Hi,

I have incident create time and incident close time in timestamp format,I am using that field in qlik nprintinng report the problem is that then the output of both create time and close time as date# format.any idea how to get it display as ddmmyyyy TT.

Regards,

Raju

Re: Time stamp issues

Ruggero_Piccoli — Wed, 31 Jan 2024 16:29:06 GMT

Hi,

February 2021 is out of support so I suggest you to plan an upgrade to a supported version.

There are many conversations here about date formats so I suggest to check previous post and the guide written by @Lech_Miszkiewicz that you can find at https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/

Another suggestion could be to set a format and force the export as a text by using the Text() formula in the source Qlik Sense app. You could also try to remove the Keep source format option on the date fields and customize the two columns in the Excel template.

Best Regards,

Ruggero

Re: Time stamp issues

Raju_6952 — Wed, 31 Jan 2024 18:30:59 GMT

Hi @Ruggero_Piccoli ,

Used Text(OrderDate, 'YYYY-MM-DD HH:mm:ss TT') but this object not found even after updating metadata.

Any other way to fix it?

Regards,

Raju

Re: Time stamp issues

Ruggero_Piccoli — Thu, 01 Feb 2024 08:07:36 GMT

Hi,

If you not find a Qlik Sense object in a node of the Qlik NPrinting tree after reloading the cache, it means that the type of the object is not supported by that node. You can try to search the same object in another node, for example in Images, and check it there it is visible.

Best Regards,

Ruggero

Re: Time stamp issues

Raju_6952 — Thu, 01 Feb 2024 08:44:48 GMT

Hi @Ruggero_Piccoli ,

Thanks for the update, will check the same.