AyaNova service management & work order software
AyaNova Support Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Can't format Contract Expires date field Expand / Collapse
Author
Message
Posted 10/11/2006 9:33:14 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 1/28/2009 6:40:27 AM
Posts: 32, Visits: 204
Hi There

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

Post #2139
Posted 10/11/2006 10:04:35 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: 3/17/2010 7:34:22 AM
Posts: 2,190, Visits: 5,029
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.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #2141
Posted 10/11/2006 1:16:00 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: 3/17/2010 7:34:22 AM
Posts: 2,190, Visits: 5,029
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

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #2153
Posted 11/16/2006 11:40:55 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: 3/17/2010 7:34:22 AM
Posts: 2,190, Visits: 5,029
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 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
Post #2273
Posted 9/24/2009 8:17:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 9/24/2009 8:30:38 AM
Posts: 3, Visits: 8
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

Post #4821
Posted 9/24/2009 8:27:11 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: 3/17/2010 7:34:22 AM
Posts: 2,190, Visits: 5,029
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 http://forum.ayanova.com/Topic2271-100-1.aspx and follow its example; and then let me know it now works for you once you have done so. 

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #4823
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: AyaNova Sales & Support

Permissions Expand / Collapse

All times are GMT -8:00, Time now is 12:35am

Powered by InstantForum.NET v4.1.4 © 2010
Execution: 0.031. 9 queries. Compression Disabled.