Date Function

[hianjali]

Hello,

I am using MS Access 97. I need to pull out the records which has effective date more than 6 months from todays date.. i wrote my query as follows

SELECT elgdep.MEM_SOC_SEC_NUM, elgdep.MEM_DEP_CODE, elgdep.MEM_BIRTH_DATE, elgdep.MEM_EFFEC_DATE
FROM elgdep
WHERE (((elgdep.MEM_EFFEC_DATE)>DateAdd('m',6,[Today's Date])));

I get an error...but if i change DateAdd to DateDiff it works but gives me wrong data...please someone help

 

[THWatson]

hianjali
Try...
WHERE (((elgdep.MEM_EFFEC_DATE)>DateAdd("m",6,Date()))

Tom