From within the Client display grid showing the fields Client, Contract and Contract Expires I've generated a new detailed report. I've tried to format the Contract Expires field to dd MMM yyyy, but no matter what I do it still shows in the default date/time format.

I've noticed a couple of other issues reported with date/time format on summary reports, but this is a detailed report so is this a known issue?

Regards - Brian

I am able to recreate this using a Detailed Report Template from the Clients grid as well.

I have placed this on the maintenance list to look into as it's going to require indepth coding to determine why it is occurring with the Detailed report from this grid.

I will also test doing some scripting to see if there is another way around this. I will post back here if I am able to find a work around.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

Unfortunately even with a script to attempt to directly format the field, the contract expires field is not able to be formated differently than how it presently displays.

This will stay on our maintenance list to look into until we find a script or workaround

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

Have just posted a sample report template with the steps and script to be able to format a date field that won't accept formating just using the FormatString property in topic http://forum.ayanova.com/Topic2271-100-1.aspx

In this detailed report template, the date is using a "SmartDate" which actually is in string format resulting in the same data format issue that summary report templates encounter.

The topic above provides steps to format the date field which you can apply to your Client detailed report template.

Any questions do let me know.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com