Pixel Perfect Date Formatting when Date Field Used as a Level

[Frank_S]

When a date field is used for or inside a Level in Pixel Perfect, the output may not be interpreted as expected.

You expect to see something like: 2017/05/31

You actually see: yyyy/MM/dd

Environment:

• Qlik NPrinting 

This is the expected behavior of the underlying DEV Express platform upon which Pixel Perfect is designed

Resolution:

To resolve this, you need to perform some scripting on the 'date' field within the Pixel Perfect editor.
 
The scripting involves the following steps.

1. Set up your Pixel Perfect report with a 'level'
2. Drop your 'date' field into the template editor inside the level
3. Click on the 'date' field
4. Click the Scripts button in the Template Editor top right corner
5. Next choose the 'before print' drop down option
6. Insert the following code:
   

   private void label1_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) {
         XRLabel label = (XRLabel)sender;
       double x = Convert.ToDouble(label.Text);
       DateTime myDate = DateTime.FromOADate(x);
       label.Text=myDate.ToString("dd/MM/yyyy");
   }​

7. Click 'Validate' to accept the new line of code (note that you may need to use case sensitivity for MM and dd and or yyyy)
8. Deselect the 'Scripts' button on the top left corner of the template editor
9. Preview your report

[Lauri]

I'm grappling with this date issue with Levels in PixelPerfect, and the script solution isn't working, nor is wrapping the field with Text() in Sense. Hoping there's a newer solution... Using NPrinting May 2021 and Sense November 2021.

[Sonja_Bauernfeind]

Hello @Lauri 

I would recommend posting what you are having a challenge with in our NPritning Discussion forums. This way you can make use of our active community and support engineers monitoring the forums.

All the best,
Sonja