Reply to thread

Message: [QUOTE="TC, post: 2547199"] On the face of it, your test will select all records where nextcpr is set to a non-null date which is less than or equal to today's date plus 30 days. So, for example, it might select records with dates 10 years ago. (10 years ago is <= today + 30 days) is that what you want? Also, It is dangerous to use the #...# format for dates unless you explicitly format the date into mm/dd/yyyy format within the statement. Try: nextcpr <= #"& Format$ (DateAdd("d", 30, Date()), "mm/dd/yyyy") & "#" HTH, TC [/QUOTE]