Working with dates can be complicated. No matter the technology, JavaScript or SQL, Sage CRM implementers can feel pain.
When customizing Sage CRM, you can’t run away from date manipulation. Almost every customization an implementer builds will have some component where date/time needs to be obtained from the user, stored in a database, and displayed back to the user.
If you ask any consultant about their experience handling date and time data and they will probably share some war stories.
"Then will he strip his sleeve and show his scars."
The handling of date and time fields is not impossible but getting it right can often take longer than imagined.
This is a Round Up of the different articles that we have written on working with date and time fields. These should suggest some tricks that can help you avoid date/time distress.
Formatting Dates
General Scripting
- Convert Sage CRM date to a JavaScript date
- Getting around Date field limitations
- Useful Date Functions
- Setting or Updating Date Fields using a Table Level Script
- Populating Default Date Field Values
- Including Islamic Dates in Sage CRM
- Easy way of grabbing a user's date preferences
- Working around Date/Time field issues in Web to Lead forms
- Date and Times in Escalation Rules
- Add/Subtract Days to a Date and pass to a Record Object
Dates in SOAP Web Services
- Date/Time fields, User Preferences and SOAP Web Services
- Using the SOAP Web Service to add a Lead and set the Opened Date and Assigned User values
- Setting DateTime fields to null via the (SOAP) Web Services Interface
Validation of Data