Solved: Time stamp issues - Qlik Community

Raju_6952 · ‎2024-01-31

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

Ruggero_Piccoli · ‎2024-01-31

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

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

Ruggero_Piccoli · ‎2024-01-31

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

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

Raju_6952 · ‎2024-01-31

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

Ruggero_Piccoli · ‎2024-02-01

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

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

Raju_6952 · ‎2024-02-01

Hi @Ruggero_Piccoli ,

Thanks for the update, will check the same.

Time stamp issues

Other

Qlik NPrinting February 2021