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 DD/MM/YY… Read More »
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 »
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.