CRM 4.0 Allow a year of 9999 RRS feed

  • Question

  • Is there a way to allow for a date of 12/31/9999 ?

    This is a requirement to reflect data in another system.  Currently I'm converting it to 2099.......

    David Withers
    Tuesday, August 30, 2011 5:19 PM


  • Hi,

    The maximum possible allowed in SQL Server is 12-31-9999 23:59:59.997 , CRM converts all input datetime into UTC and then store in database due to the day/ligh saving nad timezone changes the maximum allowed datetime value set for CRM is 12-30-9999 and there is not standard functionality available to change the maximum value criteria for CRM 2011 DateTime field unless you manually change the values into the CRM database (unsupported customization and highly unrecommended approch).

    Update: if it is required then you may also consider using the Text field to store the date value 12/31/9999 in text format

    Jehanzeb Javeed

    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".

    Tuesday, August 30, 2011 6:10 PM