I have some data with a field for date (created). I have to adjust the date fields, moving it back 8 hours. I've done it two ways, one using the DateDiff(field) and the other just subtracting .3333 (1/3 of an day) from the "created" field.
I can filter fine (reducing the list to a specific time frame) on the original date field:
SELECT T_Sales.Created, CDate(DateAdd("h",-8,[Created])) AS NewCreated, CDate([Created]-0.33333333) AS NewCreated2, T_Sales.SalesTotal
WHERE (((T_Sales.Created)>=[from] And (T_Sales.Created)<[to]));
But when I try the same type of filtering on the adjusted date, it doesn't work.
Any idea what I'm doing wrong?
But when I try to filter on the new field