topic Nprinting Doesn't display date format in Qlik NPrinting

Nprinting Doesn't display date format

lior_malcka — Tue, 26 Jan 2016 00:27:33 GMT

Hello,

my Nprinting suddenly started to present dates as numbers, I tried to reinstall Nprinting but its still showing the numbers.

The function show the date but on the excel I see numbers

Help please,

Thanks

Re: Nprinting Doesn't display date format

Tue, 26 Jan 2016 17:24:35 GMT

Right click on the Excel cell and then Format the cell to show as a date.

If that doesn't work, then use =date(today(),'mm/dd/yyyy') as your formula.

Re: Nprinting Doesn't display date format

Anonymous — Tue, 26 Jan 2016 17:53:04 GMT

You can use the date format command right in your formula on the Nprinting side.

You can orient to MM/DD/YYYY or several other combinations to get what you want

Re: Nprinting Doesn't display date format

lior_malcka — Tue, 26 Jan 2016 19:12:15 GMT

hey its working but only on excel, if i try to work on powerpoint or pixel perfect I see numbers.

thanks

Re: Nprinting Doesn't display date format

lior_malcka — Tue, 26 Jan 2016 19:22:45 GMT

Not working

thanks

Re: Nprinting Doesn't display date format

Tue, 26 Jan 2016 19:45:18 GMT

Which method did you use to get it to work in Excel? Did you change the cell formatting, or did you change the formula?

Re: Nprinting Doesn't display date format

Anonymous — Tue, 26 Jan 2016 19:55:54 GMT

It appears that you have an older version of NPrinting. Should not be a reason why the date formula won't work. As a work around, you can try to create a variable in your QV app with this data formula. Make a text box to show the variable so that you can see the correct format. You can then add the variable to your Excel Template.

Re: Nprinting Doesn't display date format

lior_malcka — Tue, 26 Jan 2016 19:57:19 GMT

I changed the cell formatting in the Excel.

Re: Nprinting Doesn't display date format

Anonymous — Tue, 26 Jan 2016 19:59:48 GMT

Try :

=text(date(today(),'mm/dd/yyyy') )

Re: Nprinting Doesn't display date format

psankepalli — Tue, 26 Jan 2016 20:17:33 GMT