or i selects

WHERE
((WPMProjectFlow.StartDate < '07/01/02') AND
(WPMProjectFlow.StartDate < '07/08/02') )

OR

((WPMProjectFlow.StopDate > '07/01/02') AND (WPMProjectFlow.StopDate > '07/08/02') )

Som sagt har jeg forsøgt mig med paranteser. Det virker ikke. Når jeg exerkverer min select i sql-manageren bliver paranteserne fjernet og den indsætter sine egne.

Hvor prøver du henne?

I enterprise managerens SQL-panel. Hvis det kan hjælpe ser hele statementen således ud:

SELECT    ACMUser.Username, WPMProjectFlow.ID, WPMProjectFlow.UserID, WPMProjectFlow.StartDate, WPMProjectFlow.StopDate,
                      WPMProjectFlow.ActualStartDate, WPMProjectFlow.ActualStopDate, WPMProjectFlow.WorkTypeID, WPMProjectWorkType.Name AS pname,
                      WPMProjectFlow.Name, WPMProjectFlow.Description
FROM        ACMUser INNER JOIN
                      WPMProjectFlow ON ACMUser.ID = WPMProjectFlow.UserID INNER JOIN
                      WPMProject ON WPMProject.ID = WPMProjectFlow.ProjectID INNER JOIN
                      WPMProjectWorkType ON WPMProjectFlow.WorkTypeID = WPMProjectWorkType.ID
WHERE    (WPMProject.Active = 1) AND (WPMProjectFlow.StartDate > '01/01/02') AND


(WPMProjectFlow.StartDate < '07/01/02') AND
(WPMProjectFlow.StartDate < '07/08/02')
OR
(WPMProjectFlow.StopDate > '07/01/02') AND
(WPMProjectFlow.StopDate > '07/08/02')



AND (WPMProjectFlow.ProjectID = 7)
ORDER BY WPMProjectFlow.StartDate

Prøv at skrive dato'erne i USA format 'yyyy-mm-dd'

dit udtryk:
(WPMProjectFlow.StartDate < '07/01/02') AND
(WPMProjectFlow.StartDate < '07/08/02')
er det samme som:
WPMProjectFlow.StartDate < '07/01/02'
når WPMProjectFlow.StartDate skal være mindre end BÅDE '07/01/02' OG '07/08/02'

Niels

Du havde alligevel ret.