Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Qlik NPrinting

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Asuod_
Contributor III
Contributor III
‎2022-08-24 02:21 PM

Change Date Formatting in Straight Table Object for Excel Report NPrinting

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
Labels (2)
Labels
100 Views
1 Solution

Accepted Solutions
Lech_Miszkiewicz
MVP
MVP
‎2022-08-24 11:37 PM

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?

Lech_Miszkiewicz_0-1661398590110.png

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

65 Views
1 Reply
Lech_Miszkiewicz
MVP
MVP
‎2022-08-24 11:37 PM

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?

Lech_Miszkiewicz_0-1661398590110.png

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
66 Views