topic Re: Pixel Perfect Date field format in Reporting Service & Alerting

Pixel Perfect Date field format

kenr169387 — Thu, 15 May 2025 15:01:14 GMT

I have an "Order Date" column in a table where the table is bound to a level. The date column is a date.autocalendar.date from the qlik load script. It displays the date correctly in the qlik table and displays the date datatype icon in the pixel report field list. The column is placed in a DetailReport3 band bound by the OrderID. The date is appearing as a serial number, instead of the date format. Wrapping the field in functions like MakeDate(), text(), Date, Date#, and combinations of these functions have not yet succeeded. What's the magic formula to get the date to show?.

Re: Pixel Perfect Date field format

Ruggero_Piccoli — Fri, 16 May 2025 06:51:41 GMT

Hi,

Create a new calculated column with the magic formula AddDays(#1899-12-30#, [OrderDate]) and then format it as you prefer in the PixelPerfect template.

Best Regards,

Ruggero

Re: Pixel Perfect Date field format

kenr169387 — Fri, 16 May 2025 14:24:04 GMT

Yeah I never would have guessed that one, but it makes sense now. Since the serial number is just a count of days since 1899-12-30, just add them together. Thanks!

Is there a better way I can bring a date field into the template or do I need to add a calculated field everytime?