SQL and dates in BW

Does anyone know how to use code to get a date range... I've tried using SQL code to get a specific date and it continues to come back as an error.  I know dates are tricky things to work with in SQL.