您好，我要在如下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
加好友 
发短信
Post By：2019/8/14 21:12:00 [只看该作者]
