06-26-2009 12:15 PM
I've generated a weekly report from ACT using Notes/History Report templete.
Report came out fine, except the date format was as an example 23/06/09--instead of 06/23/09 ? I checked the help section of ACT, and can't seem to find any info regarding set up of the date format.
06-26-2009 01:17 PM
Right click on the date field in the report editor and choose properties and the format tab and select the date format desired.
That method works when you are working with the actual date field. However, one of the reasons I discourage modifying an existing standard template is because they often use a custom field for simple formatting and that would require changing the format expression for the custom field.
05-06-2010 02:31 AM
Thanks for that Roy it solve a problem that was annoying me a lot
Would you also know if its possible to alter which database entry a field is linked to i want to change one from Address to Home Address with out having to create the new fields from scratch
05-06-2010 08:19 AM