In a triangle, we use terms like adjacent and opposite. These refer to sides in relation to angles. In our musical triangle, the drummer is at one angle in the back. This side, where the audience is, is called the opposite side.
Trunc is database function, try using round for numeric values, or change the Processing of Query to database.
Here is another option. Create a trunc function in sql server. For some reason, I have to use dbo. to run it. If anyone knows how to eliminate that part it would be helpful. Anyway, here is the function with a day, month, or year. If you need more, just add them in. CREATE FUNCTION trunc