Steve,
If you could show us your code that errors on you it would be much easier to help you out.
Keep in mind that teh delimiters for date and datetime values are the curly braces {}. So to replace a datetime field named Today with a blank would be;
REPLACE Today WITH {}