Tag Archives: dateformat

Notify if Quote is expired in Sage CRM

In Sage CRM, we can change the color of fields as per our need or business requirement. One of our client came up with a requirement that, if the expiration date has gone past the current date then it would show in Red color. Suppose you are having multiple Quotes records, but while going through… 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 »