Date changing in nPrinting

[bobbydave]

I have this app which shows Open Date.

Open Date is in the format DD/MM/YYYY HH:MM:SS

In my load script, I convert this to DD/MM/YYYY which is how I want this to appear.

However when I use nPrinting to run the report, the Open Date appears as below:

App attached.

Anyone understand why the date appears as such in nPrinting.

If I don't convert the original, it appears as DD/MM/YYYY HH:MM:SS but I don't want the time to appear in nPrinting.

Help appreciated.

**Note I have now changed the variable timestamp to only show DD/MM/YYYY as I will never need HH:MM:SS so now it shows the date. However, it still does not want to show this in nPrinting. Am I storing the Open Date incorrectly?

[bobbydave]

figured it out.

wouldn't work until I had text(.... )

text(date(timestamp([Open Date], 'DD/MM/YYYY hh:mm:ss[.fff]'), 'DD/MM/YYYY'))