Content Management and Capture

 View Only
  • 1.  Error setting DateTime property value

    Posted Mon April 01, 2024 12:58 PM

    Hi

    We are using the FileNet .NET Api dll to create documents in FileNet, but when we are trying to set the DateTime property we are getting the following error:

    The value given for a property or list element lies outside the permitted range or value set, or exceeds the maximum length allowed.

    The value (Sat Jan 01 03:00:00 AST 1) specified for property OrderDate is less than the minimum permitted (Mon Jan 01 03:00:00 AST 1753).

    Anyone can guide what is the required format for datetime we need to send or is there any datetime configuration for the required format in FileNet?

    Thanks.



    ------------------------------
    Abdul Fattah Mohammed
    ------------------------------


  • 2.  RE: Error setting DateTime property value

    Posted Mon April 01, 2024 01:21 PM

    This more like a date range issue, not the format. As far as I know, SQL Server date range is 1/1/1753 to 12/31/9999  https://learn.microsoft.com/en-us/sql/t-sql/data-types/datetime-transact-sql?view=sql-server-ver16

     






  • 3.  RE: Error setting DateTime property value

    Posted Tue April 02, 2024 08:57 AM

    Hi Abdul!

    I believe the comment above is correct. It appears that the DateTime variable you are using is using a year value of 1 and the minimum year for most languages is 1753. I would recommend adjusting your datetime variables' formatting to include the correct year value. Hope this helps!

    Best regards,

    Chris



    ------------------------------
    Christopher Hegel
    ------------------------------



  • 4.  RE: Error setting DateTime property value

    Posted Tue April 02, 2024 05:48 PM

    The format of your date time must be incorrect....based on the error it seems to be missing the year.



    ------------------------------
    RUTH Hildebrand-Lund
    ------------------------------