Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Not applicable

Date conversion problem in Nprinting

Hi ,

         In Npriniting->excel Reports in formulas i am using an expression as "date(weekend(today(),0)-7,'DD-MMM-YY')" ,

I am using this formula to display date of weekend.

while in designing report it is showing correctly but after generating into excel report the date is showing the next day date.

ex:

consider as per my formula output date is 19-mar-16 but it is showing as 20-mar-16.

can anyone give solution to this problem?

thanks in advance.

3 Replies
lubicz99
Valued Contributor

Re: Date conversion problem in Nprinting

Greetings,

I was able to duplicate your error.  Definitely peculiar.   I tried several variations of your formula in an Excel template without success.  I then tried using your formula in a power point template and it worked fine.  So, my conclusion is that Excel is not interpreting the formula the same way that Nprinting is.

You might try creating your formula in your QV app and assign it to a variable.  Then you can just drag the variable into your report as an already calculated date, thus eliminating the "mis-interpretation" of the formula by Excel.

Hope that helps

Not applicable

Re: Date conversion problem in Nprinting

thks for the reply mike,

I tried as variable but still no improvement in results.

it is showing same results.

lubicz99
Valued Contributor

Re: Date conversion problem in Nprinting

I think you need to make sure the formula is evaluated in QV and only the result is passed to Nprinting.   If you are passing the variable formula to Nprinting, you get the same error. 

For example, do you have an = sign in your variable value.  See below

vDate Show.PNG

Create a text box in your QV app to test and see what your formula outputs.  This is =vDateShow

vDate Show Output.PNG

Hope that works for you

Community Browser