Browse by Tags

• ASP
• Code Snippets
• Columns
• COM
• create script
• CurrentUser
• Date
• Date/Time
• entity level script
• EntryTypes
• ewaress.js
• Fields
• Hijri
• Islamic Dates
• Javascript
• null
• Record Object
• Regular Expressions
• Sage CRM 6.2
• Search Select Advanced
• Self Service
• serverside
• SQL
• table level scripts
• time
• update
• Validation
• Values() Collection
• Web Services
• Web To Lead
• Workflow

• Setting DateTime fields to null via the (SOAP) Web Services Interface

  This follows on from the article " How do you set a null value via (SOAP) Web Services? ". Part of the difficulty in setting DateTime fields to null via webservices is that System.DateTime in... Posted Dec 29 2009, 12:28 by Jeff Richards with | with no comments Filed under: Web Services, dates, Date/Time, Date, null, update

• Working around Date/Time field issues in Web to Lead forms in Sage CRM 6.2

  The feature 'Web to Lead' in Sage CRM enables you to create web pages for collecting lead information automatically. The process generates the HTML to define a web form page for entering lead details... Posted Oct 01 2009, 09:30 by Jeff Richards with | with 1 comment(s) Filed under: Fields, dates, Sage CRM 6.2, Web To Lead, Date/Time, Date

• Useful Date Functions

  Occasionally you will need to fetch a date from either the CRM database or perhaps from an external system that is then needs to be formatted so it looks like a CRM date. All users are able to set their... Posted Jul 10 2009, 10:48 by Jeff Richards with | with 4 comment(s) Filed under: ASP, COM, Code Snippets, Columns, Fields, dates, Javascript

• Add/Subtract Days to a Date and pass to a Record Object

  This article has been updated.(again 14th April 2009) Dates can be a bit of a challenge. This article explains three points: how to convert a record’s date field value into a JavaScript Date object. how... Posted Apr 14 2009, 12:05 by Jeff Richards with | with 4 comment(s) Filed under: COM, Record Object, dates

• Self Service Workarounds

  This article has been updated to correct links and to correct code. There have now been a few articles posted here that discuss Self Service . So if you have been reading these or have been working with... Posted Mar 13 2009, 09:49 by Jeff Richards with | with no comments Filed under: ASP, COM, Search Select Advanced, Self Service, Fields, EntryTypes, dates, Sage CRM 6.2, ewaress.js

• Validation of Dates

  The validation of dates can be tricky. Partly this is due to jscript and partly down to the flexibility that Sage CRM provides in allowing dates to be presented. I have covered how default values dates... Posted Dec 29 2008, 11:46 by Jeff Richards with | with 2 comment(s) Filed under: COM, entity level script, table level scripts, Validation, dates, Regular Expressions

• Validating Time

  A way of validating time is possible by taking advantage of the way Date/Time fields are added into Sage CRM. For example if you add a new Date/Time field into the company table, e.g. comp_customersincedate... Posted Dec 29 2008, 10:46 by Jeff Richards with | with no comments Filed under: COM, Validation, Values() Collection, dates, time

• Populating Default Date Field Values

  This article has been updated. Create Script example Date/Time fields can can have their values set by using the DefaultType property. If DefaultType set to 6 then the field displays the Current Date/Time... Posted Dec 29 2008, 09:50 by Jeff Richards with | with no comments Filed under: Workflow, create script, Fields, dates

• Easy way of grabbing a user's date preferences

  In Sage CRM an individual user can set their own date preferences that control how CRM date and datetime fields are then displayed. This is done in the My CRM, Preferences tab screen. If you are trying... Posted Dec 08 2008, 01:55 by Jeff Richards with | with 1 comment(s) Filed under: dates, CurrentUser, serverside

• Including Islamic Dates in Sage CRM

  This article has come about because of a question from a partner working on implementing Sage CRM where the customer would like dates shown according to the Hijri (Islamic) calendar. This is a subject... Posted Dec 04 2008, 05:43 by Jeff Richards with | with no comments Filed under: SQL, dates, Islamic Dates, Hijri