Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a word report where I need to display a date.
The date comes from qlik sense with a format that I don't want and I need to change.
In Properties for the specific field, I tried to enter a format value (eg 'DD/MM/YY') but nothing changes.
Is it possible to change the format from nprinting?
Please, see the attachment screenshot.
Hi,
You could format the date in Qlik Sense and force it to export as a text by using the Text() function.
Best Regards,
Ruggero
Hi Ruggero,
That's what I was trying to avoid...
But why can't I do this in nPrinting? And if I can't why there is the format option in the properties of each field in the report?
Thank you,
Nikos
Hi,
I think the date field is interpreted as text field and not date when exported from Qlik Sense so the format set in the properties is not applied.
Best Regards,
Ruggero
Hello,
Is there any doc for the format option? I didn't find any info in nPrinting documentation that describes the way we must enter the format as well as other information (text to date convertion etc)
BR,
Nikos