We’ve been using Teradata with BO for years; the one date-related gotcha that comes to mind is mistaking TIMESTAMP and DATE data types for each other. Once you know the actual datatype, you can manipulate the data accordingly. Like this, for example.
charlie 
(BOB member since 2002-08-20)