Tag Archives: Date

How to Customize the Time picker list

In sage CRM, date and time field play an important role. User can add customized data time field according to their business requirement and can have multiple customization related to these fields. Usually Date Time field are added with date and time pickers. Where date picker shows calendar and time picker shows time list with half an hour interval as shown… Read More »

Set Date Format in New Self Service Portal

Sage CRM Self Service portal is designed in such a way that we can use the Sage CRM user interface and customize it as per the requirement. Its access can be given to customer so that they can stay updated with their cases, leads, tasks or other information which we want to share with them.… Read More »

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 »