blocks|key|378503|text|这意味着程序中的某个地方正试图将OLE自动化日期转换到或从有效范围以外的OLE自动化日期(公元前1-4713年)到公元31-999年12月31日。这可能是因为OLE自动化日期表示为一个双。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|378504|首先，寻找这些方法的任何用途：|378505|DateTime.FromOADate|378506|DateTime.ToOADate|378507|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/system.datetime.fromoadate.aspx|1|http://msdn.microsoft.com/en-us/library/system.datetime.tooadate.aspx^0|2K|1|0|0|0|J|0|0|0|H|1|0^^$0|@$1|2|3|4|5|6|7|V|8|@$9|W|A|X|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Y|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|Z|8|@]|D|@$9|10|A|11|1|12]]|E|$]]|$1|J|3|K|5|6|7|13|8|@]|D|@$9|14|A|15|1|16]]|E|$]]|$1|L|3|-4|5|6|7|17|8|@]|D|@]|E|$]]]|M|$N|$5|O|P|Q|E|$R|S]]|T|$5|O|P|Q|E|$R|U]]]]

It means that somewhere in the program is attempting to convert to or from an OLE Automation Date outside the valid range 1-January-4713 BC to 31-December-9999 AD. It might have slipped through because OLE Automation Dates are represented as a double.

Start by looking for any uses of the methods:

<a href="http://msdn.microsoft.com/en-us/library/system.datetime.fromoadate.aspx" rel="noreferrer">DateTime.FromOADate</a>

<a href="http://msdn.microsoft.com/en-us/library/system.datetime.tooadate.aspx" rel="noreferrer">DateTime.ToOADate</a>

blocks|key|1913729|text|OADate表示为双值，其值为1899年12月30日午夜起的天数(负值代表较早的日期)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1913730|当试图将一个位于Ole自动化有效日期范围之外的值转换为/从一个.NET+DateTime值(方法DateTime.FromOADate和DateTime.ToOADate+-这些方法也被隐式地用于COM+Interop)时，将引发此异常。|1913731|我认为转换为OADate是有效的，.NET+DateTime值必须严格大于01/01/0100。|1913732|要从OADate转换为.NET+DateTime值，双值必须严格大于-657435+(=+01/01/0100)和严格小于2958466.0+(01/01/10000)。|1913733|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

An OADate is represented as a double value whose value is the number of days from midnight on 30 december 1899 (negative values representing earlier dates).

This exception is thrown when trying to convert a value that is outside the valid range of Ole Automation dates to/from a .NET DateTime value (methods DateTime.FromOADate and DateTime.ToOADate - which are also used implicitly for COM Interop).

I believe to be valid for conversion to an OADate the .NET DateTime value needs to be strictly greater than 01/01/0100.

To convert from OADate to a .NET DateTime value, the double value needs to be strictly greater than -657435 (= 01/01/0100) and strictly less than 2958466.0 (01/01/10000).

blocks|key|723213|text|这意味着您在某个地方提供了一个无效的日期，试图转换到或从一个OLE自动化日期以外的有效范围1-1月-4713公元前31-12月-公元999年。一个可能的原因是，它可能已经通过，因为OLE自动化日期表示为双。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|723214|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

It means you provided an invalid date somewhere, attempting to convert to or from an OLE Automation date outside the valid range 1-January-4713 BC to 31-December-9999 AD. A possible cause is that it might have slipped through because OLE Automation Dates are represented as a double.

blocks|key|378468|text|其他人也在努力解决这个问题。我建议在DotNetNuke和DevShed上查看这些线程。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|378469|entityMap|0|LINK|mutability|MUTABLE|url|http://www.dotnetnuke.com/Community/ForumsDotNetNuke/tabid/795/forumid/8/threadid/64010/scope/posts/Default.aspx|1|http://forums.devshed.com/net-development-87/not-a-legal-oleaut-date-error-337459.html^0|I|A|0|T|7|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

Others have struggled with this. I suggest looking at these threads on <a href="http://www.dotnetnuke.com/Community/ForumsDotNetNuke/tabid/795/forumid/8/threadid/64010/scope/posts/Default.aspx" rel="nofollow noreferrer">DotNetNuke</a> and <a href="http://forums.devshed.com/net-development-87/not-a-legal-oleaut-date-error-337459.html" rel="nofollow noreferrer">DevShed</a>.

blocks|key|378551|text|我用过：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|378552|try
{
++++if+(folderItem.ModifyDate.Year+!=+1899)
++++{
++++++++this.FileModifiedDate+=+folderItem.ModifyDate.ToShortDateString()+%2B+
++++++++++++"+"+%2B
++++++++++++folderItem.ModifyDate.ToLongTimeString();
++++}
}
//we+need+this+because+it+throws+an+exception+if+it's+an+invalid+date...
catch+(ArgumentException)+{+}+|code-block|syntax|javascript|378553|来处理我遇到的同样的问题。当我们检查我的年份时，它会抛出异常。在无效日期不做任何事情正是我想要的行为，所以这个黑客是有效的。|378554|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I've used:

<pre><code>try
{
 if (folderItem.ModifyDate.Year != 1899)
 {
 this.FileModifiedDate = folderItem.ModifyDate.ToShortDateString() + 
 " " +
 folderItem.ModifyDate.ToLongTimeString();
 }
}
//we need this because it throws an exception if it's an invalid date...
catch (ArgumentException) { } 
</code></pre>

to deal with the same problem I'm having. It throws the exception when we check the year in my case. Doing nothing on an invalid date is exactly the behavior I want, so this hack works.

blocks|key|1913786|text|我发现有一个大的row_id+'257381195‘的专栏正试图用Excel作为日期来阅读。我最后做的是通过在row_id前面加上一个单引号，将该列的数据更改为一个字符串。这解决了我的问题。希望这能有所帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1913787|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

What I found was that a column with a large row_id '257381195' was attempting to be read by Excel as a Date. What I ended up doing was altering that column's data to a string by preceding the row_id with a single quote. This resolved my issue. Hope this helps.

Does anyone know what this means. Getting this in C# winforms applications:

<blockquote>
 Not a legal OleAut date
</blockquote>

Meaning of exception in C# app: "Not a legal OleAut date"?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

有人知道这意味着什么吗。在C# winforms应用程序中实现这一点：不是合法的OleAut日期

问C#应用程序中异常的含义：“非合法的OleAut日期”？
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问C#应用程序中异常的含义：“非合法的OleAut日期”？EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问C#应用程序中异常的含义：“非合法的OleAut日期”？
EN