format$ query

[ActuateNewbie]

Hi

I am looking at an Actuate report that someone else has developed. The report says "No pages to display" when I run the report for a specified date and I am trying to debug report.

Looking at the SQL, there is a condition that includes format$(startdate,"MM/DD/YYYY HH:NN:SS").

Does anyone know if this NN part of the format is valid? Doesn't look familiar. If not valid, how does Actuate cope with this at runtime?

Just wondering whether this is why it can't find data.

thanks

 

[ASG0856]

Yes, NN (or nn) will return minutes with leading zeroes.