Hello all I have spent the last few hours trying to query a table with some date fields to no avail. I have a tasks table with taskCreateDate taskTargetCompleteDate and taskCompleteDate. I'm trying to create a query that looks for taskTargetCompleteDate for the next 30 days. Will someone please provide an example? I tried <= date() +30 but I have no idea where to start. How can I do this based upon current date <= 30 days out?
-- Regards Dave Ashmore SOHO IT Solutions LLC 1934 S. Delaware Dr. Easton, PA 18042 610-258-7128 http://callsohoit.com We now support the Linux Desktop Disclaimer: The below quote is randomly generated and I may or may not agree with the quote. So here is your random bit of wit. ################################################################ (definitions) % party, n.: A gathering where you meet people who drink so much you can't even remember their names. ################################################################ -- 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. ################################################################ (miscellaneous) % I have seen the Great Pretender and he is not what he seems. ################################################################ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
