AND DATESUBMITTED >= DATEADD(day, -5, #thedate#) might want to check the syntax on that...
> -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: 20 March 2003 16:51 > To: '[EMAIL PROTECTED]' > Subject: [ cf-dev ] brain freezo : dates > > > How could limit my results query using this > > AND DATESUBMITTED = '#TheDate#' > > but making sure the system only returns back the results from > todays date > minus 5 days..? (are a set amount of days) > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
