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?.
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
Best Regards, Ruggero --------------------------------------------- When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
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
Best Regards, Ruggero --------------------------------------------- When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
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?
