urgent help needed

[Bazzelle]

I'm in need of modifying the following passthrough query to pull StatusDate between 9/20/2011 and 9/22/2011 instead of checking WHERE post status is "posting"

SELECT [Id]
,[Action]
,convert (int,( convert (varchar,(convert(xml, convert(nvarchar(max), [Body]))).query('declare namespace x="http://PRISMSerialize"; (/SolomonInterfaceTransport/x:Id/text())')))) as Result
,[Status]
,[StatusDate]
,[UserSentId]
FROM [Prism].[dbo].[InterfaceQueue]


where [Status] = 'posting'

 

[Bazzelle]

solved, thanks.