Hi There
From within the Client display grid showingthe fields Client, Contract and Contract ExpiresI’ve generated a new detailed report. I’ve tried to format the Contract Expires fieldtodd 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 sois this a known issue?
Regards - Brian
Hi 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.
Hi
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
Hi again
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 How-to-format-date-field-if-using-Summary-report-template-designer
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.
We are just wondering if this issue has now been addressed in ver. 5. We are wanting to create reports in workorders, units, clients etc. without the time printing. We have tried formatting the date fields in several reports and they do not change from the default. Please advise.
Ken
Hi Ken
The posting immediately before yours does provide example on how to format a SmartDate which that datafield is. It was never a bug, it was a case of if a SmartDate, has to be done as per that topic.
As it states, do review the topic How-to-format-date-field-if-using-Summary-report-template-designer and follow its example; and then let me know it now works for you once you have done so.