Most Recent Date (Nprinting)

[default_the_pig]

Hello,

I have a report that I'm trying to do Nprinting on. I have two sheets. On the first sheet, I have a Date Filter called "Date"and on the second sheet, I have another Date filter called Reconciliation Date. 

I'm trying to get an HTML Nprinting going so that both sheets show the most recent date based on the filter selected. 

I'm able to get the first sheet working. I was able to go to "Evaluate Search" Under Filters and did a MAX(Date) and the report ends up selecting the most recent date based off the Date Filter.

But when I try to do the second sheet, I get an error  "false to current data" when trying to do MAX(Reconciliation Date) under Evaluate Value. But it doesn't makes sense to me. I have the correct sheet selected. I'm not sure what's going on here. 

Another possible solution that I found was this

Nprinting:
LOAD MAX(DATE([Date Of Reconciliation])) AS [Max Date Of Reconciliation]
RESIDENT CBSFinal;

LET vNprinting = PEEK('Max Date Of Reconciliation', 0, 'Nprinting');
DROP TABLE Nprinting;

DROP TABLES Source, Target,FinalTemp,CDN,BW,Usage;

Letting the variable select the MAX date. So on the front end variable, it looks like 11/23/2021 which is what I want. But I'm not sure how to get Nprinting to show the most recent date based off of my backend code above. 

@Nicole-Smith 

[stevejoyce · Accepted solution]

Maybe this would fix it?  MAX([Reconciliation Date]) field names with spaces/special characters need brackets.

[default_the_pig]

Yes, you're absolutely right! It did work. Thank you!

This was driving me nuts. I'm wondering how MAX(Date) worked without any brackets but every other field needed brackets.