Tag Archives: Date

Set Default Value for Date Field through Script

In Sage CRM customizations, scripting has been proved essential for developers to justify trivial requirements with an ease. It provides the flexibility to set validations or values in field at screen level. Though this can be achieved through few configurations in CRM, but it does not allows you to limit the setting up to certain… Read More »

Setting Default Date Time while progressing through Sage CRM Workflow

Sage CRM can be customized for reducing the data entry task by setting default values in some fields while entering data. There is an option of automating the task of feeding in same data in several records by Setting default values in Sage CRM. GUMU Sage 100 : Creating Order with existing Opportunity in GUMU… Read More »

Error saving value in Date field

What all methods do we need while updating data to the CRM database? We can use CreateRecord, FindRecord or either simple Update query and ExecSql can also update the data in CRM database as per our need. Now the hitch is always when the date field comes into picture. Consider the scenario, you have created… Read More »

Change Default Language/ Date Format in SQL

Usually in SQL, date gets saved as ‘2009-07-27 00:00:00.000’ but when we run the query or call date from any application the SQL gives us the date in desired format like ’07/27/2009’. How does it work? SQL has set of formats according to the different languages for example ‘British’, ‘Dutch’, ‘German’, ‘English’ etc. By Default… Read More »