I am creating my first Pixel Perfect report and am bringing in 2 date fields from my app. Within my Qlik Sense script, I am applying Date() and Floor() functions to both fields. Using the fields within a Detail Report they are coming through as numbers and not dates. I tried creating a calculated expression with the GetDate() function and that just returned nothing. When changing the format to Date Time, rather than it return a date in the format specified it returns the literal string that is selected in the format type (returned "MM/dd/yy" for every row). How do I format a date field in Pixel Perfect. Thanks in advanced.
I have the same issue.
I've seen some references to using a script, but not how.
I've also seen formatting the date in Qlik to make it a string; this is not really viable as I need the value to be a date in the application for other things to function. Besides, date formatting should work in NPrinting; its a pretty basic feature...
I raised this issue via the Qlik Support portal. It is a known bug and they are working on correcting it. A workaround is to create a formula in Pixel Perfect with this syntax: =text(date(Date_Field,'MM/DD/YY')). Hope this helps for the time being.