Notifications
Announcements
No record found.
There has got to be a workaround to the minimum date time of 1/1/1900. Any suggestions?
*This post is locked for comments
I did find a file in C:\Inetpub\wwwroot\_static\_controls\datetime named date.js that has the following line of code:
var _dCalMinDate = new Date(1900, 0, 1);
I changed it to 1800 and tested and still did not work. I reset IIS thinking it was cached and tried the date 1/1/1850 and it still would not let me enter that date on a form.
I assume this is the correct place to make the change and I must be missing something simple to get it to take effect. Any ideas?
MSDN: The smalldatetime data type stores dates and times of day with less precision than datetime. The Database Engine stores smalldatetime values as two 2-byte integers. The first 2 bytes store the number of days after January 1, 1900. The other 2 bytes store the number of minutes since midnight.
This is not a data type issue. The data type of the date field in SQL is datetime, not smalldatetime. In fact, I can change the date in SQL diretly but the UI for CRM does not allow it.
yes, ryanb31 is correct.
its possible to enter or update directly in sql, but the same record does not view in the crm UI, nor can enter date lesser than 1900.
any work aoround plz?
Regards,
yes.sudhanshu
I know this is really old, but it's still the first Google result for "Dynamics 365 minimum date" so I thought I'd call out that this behaviour has now changed. Quoting the documentation for Behaviour and format of the date and time field:
"Starting with Microsoft Dynamics CRM Online 2015 Update 1, the date and time fields support values as early as 1/1/1753 12:00 AM."
What version of Dynamics CRM are you using? I am able to set the date to 1800 or earlier.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
SA-08121319-0 4
Calum MacFarlane 4
Alex Fun Wei Jie 2
