SQL Date Conversion Problem

See more:

SQL

time

VBA

I built a query in MS Query / Excel, ending like this:

... AND (TSDD.PeriodEndDatePosted>={ts '2010-01-01 00:00:00'} And TSDD.PeriodEndDatePosted<{ts '2011-01-01 00:00:00'})

It works fine, note the {ts} at the end.
I then took this string:

... AND  (TSDD.PeriodEndDatePosted >= {ts '@FromDate@ 00:00:00'} AND  TSDD.PeriodEndDatePosted < {ts '@ToDate@ 00:00:00'}))

And did some Replace-ing to get:

... AND  (TSDD.PeriodEndDatePosted >= {ts '2010-01-01 00:00:00'} AND  TSDD.PeriodEndDatePosted < {ts '2011-01-01 00:00:00'}))

But when I try to execute this from an ADODB.Command I get:

Conversion failed when converting datetime from character string.

So, why doesn't it work? And what is MS Query doing differently?