<div>
this will help if you are planning to change the date format on the server<br />
<a href="http://support.microsoft.com/kb/173907" rel="ugc nofollow">http://support.microsoft.com/kb/173907</a><br />
<a href="http://msdn.microsoft.com/en-us/library/ms189491.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms189491.aspx</a><br />
use <br />
SET DATEFORMAT dmy<br />

</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
Please advise how I can change the date format in CRM 3.0 to DDMMYYYY. I have recently migrated SQL2005 and CRM3.0 to new server hardware. The date format however on the new server has reverted to US format, and I require this to be AU format above.<br />
<br />
Is there a simple option in CRM3.0 or does this need to be changed in SQL? I would have thought the format from the old server would have come across from the old server.<br />
<br />
Please advise.<br />

</div>
</div>


Hi Experts,

Please advise how I can change the date format in CRM 3.0 to DDMMYYYY. I have recently migrated SQL2005 and CRM3.0 to new server hardware. The date format however on the new server has reverted to US format, and I require this to be AU format above.

Is there a simple option in CRM3.0 or does this need to be changed in SQL? I would have thought the format from the old server would have come across from the old server.

Please advise.


this will help if you are planning to change the date format on the server
http://support.microsoft.com/kb/173907
http://msdn.microsoft.com/en-us/library/ms189491.aspx
use 
SET DATEFORMAT dmy


Change Date Format in CRM 3.0 to ddmmyyyy

Enterprise software, also known as enterprise application software (EAS), is computer software used to satisfy the needs of an organization, including businesses, schools, interest-based user groups, clubs, charities, or governments. Services provided by enterprise software are typically business-oriented tools such as online shopping and online payment processing, interactive product catalogue, automated billing systems, security, enterprise content management, IT service management, customer relationship management (CRM), enterprise resource planning (ERP), business intelligence (BI), project management, human resource management (HR), manufacturing and supply chain management, enterprise application integration (EAI), and enterprise forms automation. Enterprise software is often available as a suite of customizable programs that require specialist capabilities.

Enterprise Software

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.

Microsoft Dynamics

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.