在ERP中定义用户时报错：SqlDateTime 溢出。必须介于 1/1/1753 12:00:00 AM 和 12/31/9999 11:59:59 PM 之间

关注

原创最新推荐文章于 2026-03-08 23:52:49 发布 746 阅读 AI 写同款· GEO 优化 ›

SqlDateTime溢出该怎么解决错误出现：导入数据时出现“SqlDateTime 溢出。必须介于 1/1/1753 12:00:00 AM 和 12/31/9999 11:59:59 PM之间。” 出现这种问题多半是因为你插入或者更新数据库时datetime字段值为空默认插入0001年01月01日造成datetime类型溢出。原因分析：关于DateTime，在将DateTime类型，插入到数据库的时候，最容易出现的一种错误：“SqlDateTime 溢出。必须介于 1/1/1753 12:00:00 AM 和 12/31/9999 11:59:59 PM 之间”原因是我们在取DateTime.MinValue的值，并插立即下载

在ERP中定义用户时。

报错：

SqlDateTime 溢出。必须介于 1/1/1753 12:00:00 AM 和 12/31/9999 11:59:59 PM 之间。

原因分析：

①没有正确初始化系统面板：可能是初始化时没有选择对期间，设置是跳过这一步。

②也可能是数据库级的操作。（这种情况不多见）

原因排查：（如果确定自己没有初始化期间，这一步可以直接跳过）

在数据库里执行语句

Select CurrAbsID, FinancYear, * From AAAdm

看一下这两个字段是否有值，是什么？

解决方案：

期间生成语句

If(Not Exists(Select * From AAFinYe Tm Where Tm.AbsID = 2017))
INSERT INTO [AAFinYe] ([AbsID],[AbsName],[AbsCategory],[AbsActive],[Ref_SDate],[Ref_EDate],[Ref_Locked],[GL_SDate],[GL_EDate],[GL_Locked],[Tax_SDate],[Tax_EDate],[Tax_Locked],[SubNum],[SubType],[PeriodNum],[IsClose])
     VALUES ('2017','2017',NULL,'Y','2017/1/1 0:00:00','2017/12/31 0:00:00',NULL,NULL,NULL,'N',NULL,NULL,NULL,10,NULL,NULL,'N')


INSERT INTO [AAFin] ([AbsID],[AbsName],[AbsCategory],[AbsActive],[Ref_SDate],[Ref_EDate],[Ref_Locked],[GL_SDate],[GL_EDate],[GL_Locked],[Tax_SDate],[Tax_EDate],[Tax_Locked],[SubNum],[SubType],[PeriodNum],[IsClose],[Batch_Locked],[Sale_Locked])
     VALUES ('201701','201701','2017','Y','2017/1/1 0:00:00','2017/1/31 0:00:00','N',NULL,NULL,'N',NULL,NULL,'N',1,'M',0,'N','N','N')
INSERT INTO [AAFin] ([AbsID],[AbsName],[AbsCategory],[AbsActive],[Ref_SDate],[Ref_EDate],[Ref_Locked],[GL_SDate],[GL_EDate],[GL_Locked],[Tax_SDate],[Tax_EDate],[Tax_Locked],[SubNum],[SubType],[PeriodNum],[IsClose],[Batch_Locked],[Sale_Locked])
     VALUES ('201702','201702','2017','Y','2017/2/1 0:00:00','2017/2/28 0:00:00','N',NULL,NULL,'N',NULL,NULL,'N',2,'M',0,'N','N','N')
INSERT INTO [AAFin] ([AbsID],[AbsName],[AbsCategory],[AbsActive],[Ref_SDate],[Ref_EDate],[Ref_Locked],[GL_SDate],[GL_EDate],[GL_Locked],[Tax_SDate],[Tax_EDate],[Tax_Locked],[SubNum],[SubType],[PeriodNum],[IsClose],[Batch_Locked],[Sale_Locked])
     VALUES ('201703','201703','2017','Y','2017/3/1 0:00:00','2017/3/31 0:00:00','N',NULL,NULL,'N',NULL,NULL,'N',3,'M',0,'N','N','N')
INSERT INTO [AAFin] ([AbsID],[AbsName],[AbsCategory],[AbsActive],[Ref_SDate],[Ref_EDate],[Ref_Locked],[GL_SDate],[GL_EDate],[GL_Locked],[Tax_SDate],[Tax_EDate],[Tax_Locked],[SubNum],[SubType],[PeriodNum],[IsClose],[Batch_Locked],[Sale_Locked])
     VALUES ('201704','201704','2017','Y','2017/4/1 0:00:00','2017/4/30 0:00:00','N',NULL,NULL,'N',NULL,NULL,'N',4,'M',0,'N','N','N')
INSERT INTO [AAFin] ([AbsID],[AbsName],[AbsCategory],[AbsActive],[Ref_SDate],[Ref_EDate],[Ref_Locked],[GL_SDate],[GL_EDate],[GL_Locked],[Tax_SDate],[Tax_EDate],[Tax_Locked],[SubNum],[SubType],[PeriodNum],[IsClose],[Batch_Locked],[Sale_Locked])
     VALUES ('201705','201705','2017','Y','2017/5/1 0:00:00','2017/5/31 0:00:00','N',NULL,NULL,'N',NULL,NULL,'N',5,'M',0,'N','N','N')
INSERT INTO [AAFin] ([AbsID],[AbsName],[AbsCategory],[AbsActive],[Ref_SDate],[Ref_EDate],[Ref_Locked],[GL_SDate],[GL_EDate],[GL_Locked],[Tax_SDate],[Tax_EDate],[Tax_Locked],[SubNum],[SubType],[PeriodNum],[IsClose],[Batch_Locked],[Sale_Locked])
     VALUES ('201706','201706','2017','Y','2017/6/1 0:00:00','2017/6/30 0:00:00','N',NULL,NULL,'N',NULL,NULL,'N',6,'M',0,'N','N','N')
INSERT INTO [AAFin] ([AbsID],[AbsName],[AbsCategory],[AbsActive],[Ref_SDate],[Ref_EDate],[Ref_Locked],[GL_SDate],[GL_EDate],[GL_Locked],[Tax_SDate],[Tax_EDate],[Tax_Locked],[SubNum],[SubType],[PeriodNum],[IsClose],[Batch_Locked],[Sale_Locked])
     VALUES ('201707','201707','2017','Y','2017/7/1 0:00:00','2017/7/31 0:00:00','N',NULL,NULL,'N',NULL,NULL,'N',7,'M',0,'N','N','N')
INSERT INTO [AAFin] ([AbsID],[AbsName],[AbsCategory],[AbsActive],[Ref_SDate],[Ref_EDate],[Ref_Locked],[GL_SDate],[GL_EDate],[GL_Locked],[Tax_SDate],[Tax_EDate],[Tax_Locked],[SubNum],[SubType],[PeriodNum],[IsClose],[Batch_Locked],[Sale_Locked])
     VALUES ('201708','201708','2017','Y','2017/8/1 0:00:00','2017/8/31 0:00:00','N',NULL,NULL,'N',NULL,NULL,'N',8,'M',0,'N','N','N')
INSERT INTO [AAFin] ([AbsID],[AbsName],[AbsCategory],[AbsActive],[Ref_SDate],[Ref_EDate],[Ref_Locked],[GL_SDate],[GL_EDate],[GL_Locked],[Tax_SDate],[Tax_EDate],[Tax_Locked],[SubNum],[SubType],[PeriodNum],[IsClose],[Batch_Locked],[Sale_Locked])
     VALUES ('201709','201709','2017','Y','2017/9/1 0:00:00','2017/9/30 0:00:00','N',NULL,NULL,'N',NULL,NULL,'N',9,'M',0,'N','N','N')
INSERT INTO [AAFin] ([AbsID],[AbsName],[AbsCategory],[AbsActive],[Ref_SDate],[Ref_EDate],[Ref_Locked],[GL_SDate],[GL_EDate],[GL_Locked],[Tax_SDate],[Tax_EDate],[Tax_Locked],[SubNum],[SubType],[PeriodNum],[IsClose],[Batch_Locked],[Sale_Locked])
     VALUES ('201710','201710','2017','Y','2017/10/1 0:00:00','2017/10/31 0:00:00','N',NULL,NULL,'N',NULL,NULL,'N',10,'M',0,'N','N','N')
INSERT INTO [AAFin] ([AbsID],[AbsName],[AbsCategory],[AbsActive],[Ref_SDate],[Ref_EDate],[Ref_Locked],[GL_SDate],[GL_EDate],[GL_Locked],[Tax_SDate],[Tax_EDate],[Tax_Locked],[SubNum],[SubType],[PeriodNum],[IsClose],[Batch_Locked],[Sale_Locked])
     VALUES ('201711','201711','2017','Y','2017/11/1 0:00:00','2017/11/30 0:00:00','N',NULL,NULL,'N',NULL,NULL,'N',11,'M',0,'N','N','N')
INSERT INTO [AAFin] ([AbsID],[AbsName],[AbsCategory],[AbsActive],[Ref_SDate],[Ref_EDate],[Ref_Locked],[GL_SDate],[GL_EDate],[GL_Locked],[Tax_SDate],[Tax_EDate],[Tax_Locked],[SubNum],[SubType],[PeriodNum],[IsClose],[Batch_Locked],[Sale_Locked])
     VALUES ('201712','201712','2017','Y','2017/12/1 0:00:00','2017/12/31 0:00:00','N',NULL,NULL,'N',NULL,NULL,'N',12,'M',0,'N','N','N')

退出AIO5系统，下载【期间生成语句】——到数据库执行【期间生成语句】——然后再执行一下这个语句【Update AAAdm set IsStart = 'N'】 ——再次打开AIO5系统，即可选择正确的期间。