Currently viewing the tag: "Date"

Date Format with Suffix

By On June 24, 2011

Date formats in Sage CRM always seem to be an area of discussion. A Date is made of three elements namely Month, Date and Year and you can have various standard combinations depending on country to have a date format derived out of these three basic elements.

While it is easy to interpret a [...]

Continue Reading →

Custom filter screen with default filter on Date Field options

By On January 3, 2011

Earlier I had posted a blog:

http://sagecrmaddons.blogspot.com/2010/12/date-ing-tips.html

In which I had elaborated how to handle the date field in the custom search screen as it is little bit tedious task to do.

Now in this section I will be more descriptive on how to make the date field default in the custom filters.

Some [...]

Continue Reading →

Error saving value in Date field

By On November 3, 2010

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 [...]

Continue Reading →

Change Default Language/ Date Format in SQL

By On July 27, 2009

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 [...]

Continue Reading →

Retrieve the Current Logged- In User’s Date Format in use

By On February 22, 2009

Do you want to use the same DateFormat which is selected for Current LoggedIn User? To Retrive the same you can use the below mentioed script. You need to provide the User ID and it will return the DateFormat.

Continue Reading →

Date Calculation considering Federal Holidays.

By On December 15, 2008

Now we can Schedule the tasks and appointments End Date excluding the Weekend and Federal Holidays.

Below Mentioned Federal Holidays will be taken care of with this Script.

New Years Day: Tues., Jan. 1
Martin Luther King, Jr.: Mon., Jan. 21
Washington’s B’day: Mon., Feb. 18
Memorial Day: Mon., May 26

Continue Reading →