Formula in Excel Nprinting not Working

[Qlikuser09]

I have this formula in "Date(Max({$<[Pay Period Record]={2}>} [Pay Period End Date]), 'YYYY-MM-DD')"  which gives me an exact date , but when I try to add in this in nprinting Formula tab , it is giving me 45660 number 

[David_Friend]

@Qlikuser09 here is the help documentation:
https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/ExcelReports/Intro-Excel.htm

Have you checked the 'keep source format' box in NP Designer?

https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/ReportsDevelopment/Designer-properti....

[Aurelien_Martinez · Accepted solution]

Hi,

Text(Date(Max({$<[Pay Period Record]={2}>} [Pay Period End Date]), 'YYYY-MM-DD'))

Aurélien

[Frank_S]

Ensure to always test your expressions by inserting them into Qlik Text box in your Qlik Application before using with NPrinting.
The formula shared by @Aurelien_Martinez seem accurate and should convert your text values to date format.

[Lech_Miszkiewicz]

Hi @Qlikuser09 

@Aurelien_Martinez provided you with one solution, another solution would be to apply excel cell custom date format using excel number formatting. which will display numerical value as date.

cheers