RE: Systdate Query

try modifying it to this: datetaken in (select datetaken from cim_educationalexp where userid='#client.cim_userid#') instead of datetaken = (max(...)...) -Original Message- From: Rayna Evans [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 9:41 AM To: CF-Talk Subject: Systdate

RE: Systdate Query

Oops. Misread your message last time... Instead, try this: and datetaken between '01/01/2001 00:00:00' AND '01/01/2001 23:59:59' (substitute date where appropriate) - this will find everything for the first of this year. i don't know of a way to do this in your subquery, however... you'll

RE: Systdate Query

Thanks Dave, but it's still not quite there. Here is the scenario...maybe this will make it more clear. I have developed an application that involves a bunch of tests...when the user completes one of the tests, their results will be displayed on a profile page, there is a hyperlink on the

RE: Systdate Query

of the noggin this should work. cheers -Rice -Original Message- From: Rayna Evans [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 10:22 AM To: CF-Talk Subject: RE: Systdate Query Thanks Dave, but it's still not quite there. Here is the scenario...maybe this will make it more clear

RE: Systdate Query

Message- From: Rayna Evans [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 10:22 AM To: CF-Talk Subject: RE: Systdate Query Thanks Dave, but it's still not quite there. Here is the scenario...maybe this will make it more clear. I have developed an application that involves