主题：[求助] 增加日期条件

您好，我要在如下SQL的代码中，增加一个日期条件，就是选出所有记录的日期在两个月内的，包括空格记录。谢谢。

 

 

=Se lect  {SEOrderEntry}.FItemID,{t_ICItemCore}.FNumber,{t_Organization}.FName,FEntrySelfS0174,FAdviceConsignDate,FEntrySelfS0168,[F_105],FShortName,FHeadSelfS0150 From ((({SEOrderEntry} Inner JOIN {SEOrder} ON {SEOrder}.[FInterID] = {SEOrderEntry}.[FInterID]) Inner JOIN {t_ICItemCore} ON {t_ICItemCore}.[FItemID] = {SEOrderEntry}.[FItemID]) Inner JOIN {t_Organization} ON {t_Organization}.[FItemID] = {SEOrder}.[FHeadSelfS0151]) Inner JOIN {t_ICItemCustom} ON {t_ICItemCustom}.[FItemID] = {t_ICItemCore}.[FItemID] Where Fcancellation = 0 and FMrpclosed = 0

Where Fcancellation = 0 and FMrpclosed = 0 and 日期  > #" & date.today.addmonths(-2) & "#"

你好，有显示错误
此主题相关图片如下：捕获.jpg

如果是SqlServer，#改为单引号