Oscar,
You may want to go back and revisit what was in the trigger and why they wanted it, it sounds like they were trying to avoid some sort of date based issues in reporting.
>That was it!. Our customers DBA added a trigger to the table for "auditing purposes". Dropping the trigger solved the problem. I did not investigate what was wrong with the trigger...