Retrieving Specific Values Of Data based on timestamp

Hello:

I was looking for some assistance with respect to retrieving data from a SQL server via Microsoft Query, into Excel. The data I am trying to retrieve is for a distinct time interval. Here is what I have so far:

SELECT AnalogLive.TagName, AnalogLive.Value, AnalogLive.DateTime

FROM Runtime.dbo.AnalogLive AnalogLive

WHERE (AnalogLive.TagName In ('BWWOGI2FI-CV','BWWPS1JI0-CV','BWWPS2JI0-CV','BWARWH1TI-CV','BWWOGO1GI-CV','BWWOGO2GI-CV','BWWOGI1FI-CV','BWNFLT0FI-CV')) AND (AnalogLive.DateTime>={ts '2004-10-31 00:01:00'} And AnalogLive.DateTime<={ts '2004-11-01 00:04:00'})

This query appears to work (e.g. no syntax error), howerver it never retrieves any records. These tagnames are for online instrumentation. This is my first crack at learning SQL as I am not a programmer.....I have had to do this out of neccesity for my IT department knows nothing.


Any assistance would be greatly appreciated.

Thanks,

berebus