Change Date Formatting in Straight Table Object for Excel Report NPrinting

Asuod_ — Wed, 24 Aug 2022 18:22:16 GMT

Hello,

Within the NPrinting Designer I am bringing in a straight table in an Excel template and then wanting to convert a date field in the table from number to date (MM/DD/YYYY). Under tables and selecting the specific date field/ columns im looking to convert i have unchecked 'Keep Source Formats' and then put in Format: Date(DateField, 'MM/DD/YYYY') and it doesnt seems to work. I have also tried Date(DateField) and Date(A2) but nothing seems to work. Probably going about this incorrectly but looking for any advice. Thank you! Would like to stick with a straight table object and just change the columns.

Category	Sales	Product	Date
Home Goods	100	Chair	44439
Food	400	Hot Dog	44439
Clothing	600	Shirt	44439

Re: Change Date Formatting in Straight Table Object for Excel Report NPrinting

Lech_Miszkiewicz — Thu, 25 Aug 2022 03:37:08 GMT

yes - you are doing this incorrectly as none of those functions exists in excel! Why dont you just use cell format to convert it to DATE?

also providing a screenshot of what you do would help understand where else there could be a problem?

topic Re: Change Date Formatting in Straight Table Object for Excel Report NPrinting in Qlik NPrinting

Change Date Formatting in Straight Table Object for Excel Report NPrinting

Re: Change Date Formatting in Straight Table Object for Excel Report NPrinting