Format LastPrintDate() 1

[Jembo]

I have included the LastPrintDate() function in a cell in a report, but rather than just showing the date, I want the cell to read;

"Date of Print: dd/mm/yyyy"

I have tried concatenation using the ToDate and FormatDate functions but keep getting #ERROR.

Any ideas?

 

[BrianTyler]

I tried creating a variable in the report as:

="Date of Print " & FormatDate(LastPrintDate() ,"dd/mm/yyyy")

It failed with #ERROR until I actually printed the report and then refreshed. It looks to me as if the habndling of what is an effectively null date in a formula causes the error.

 

[BrianTyler]

I tried creating a variable in the report as:

="Date of Print " & FormatDate(LastPrintDate() ,"dd/mm/yyyy")

It failed with #ERROR until I actually printed the report and then refreshed. It looks to me as if the handling of what is an effectively null date in a formula causes the error.

 

[Jembo]

That makes sense - cheers Brian