How to do Filtering on Date column?

Do this:

1) Click on the filter button. Leave the operand as is and enter 01/01/2009 in the Values field.

2) Convert the filter to SQL. You should see that OBI adds the "timestamp" syntax to your datetime column. (This is a trick to ensure you have the right format.)

3) Now change the "equal sign" to the word BETWEEN

4) Click to the end and add the following:

AND CURRENT_DATE

You should end up with something that looks like this:

"table name"."your date column" BETWEEN timestamp '2009-01-01 00:00:00' AND CURRENT_DATE

That's your filter.

Until Next Post...keep smiling ;)