Andrew Jensen wrote: > You want to use the datediff function and the check this integer. > > There is a rather detailed example of doing this, as it might be > used for a > call back routine in a contact managment setting at - along with an > example > Base database. > > http://www.oooforum.org/forum/viewtopic.phtml?t=24480 > > That should point you in the right direction. If you have further > questions > don't hesitate to ask here on at the forum. > > HTH > > Drew Jensen > When I edit the query the wizard creates is there a way to modify the query. <= CURDATE( ) + 30 the <= curdate works but of course only for today and all previous entries. How can it be corrected or add 30 days to the curdate()? Is is just syntax I'm missing? <= CURDATE( ) + 30
-- Regards Dave Ashmore SOHO IT Solutions llc 1934 S. Delaware Dr. Easton, PA 18042 610-258-7128 http://callsohoit.com Sometimes I can be reached via Skype as djash34 Disclaimer: The below quote is randomly generated and I may or may not agree with the quote. ################################################################ (MS-FORTUNES) % In most countries selling harmful things like drugs is punishable. Then howcome people can sell Microsoft software and go unpunished? ################################################################ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
