Nprinting Date

[sikander02]

Hi ,

I am really new to Nprinting and this is the first report  I am trying to build and having trouble in using a variable in Excel sheet

I created the variable which gives us yesterdays date, works fine in QVW but if I am trying to use same variable in Nprinting excel sheet it give me value in Number format, earlieare I used it in subject line of messages worked fine.  I even tried formatting it in formula

while putting the formula, Formula result gives me desired result, but once I put this formula on sheet gives me same result as the putting the variable on sheet

Thanks

[Daniel_Jenkins]

Hi Sikander,

Use Excel formatting.

HTH - Daniel.

[sikander02]

Thanks Daniel,

I actually did it in Qlikview, created a second variable in QVW where I am converting it into text now it give me correct value. But I am not sure if this is the correct way.

Thank you once again.

[Daniel_Jenkins]

Hi Sikander,

Yes, you have choices. Any way that works for you would be the 'correct' way in my opinion

HTH - Daniel.