Report data showing a date 1 day earlier than selection formula
I have a datetime field that I am subtracting an offset to (using dateadd) and then selecting this date-time based on a date range, start time and end time as well as dayofweek selection. Similar to a problem I posted earlier last week, this time my results are showing a date 1 day earlier then my start date (all values are 0 though) plus if I deselect a day (let's say sunday), it will still show up on my report but with 0 values.
Any ideas why my selection formulas are not being adhered to properly?
Thank you in advance,