Forum Discussion

southgrad10's avatar
southgrad10
Icon for Helper II rankHelper II
2 years ago

Report in Desktop vs. Service not behaving the same

I have a report that is capturing sales for the day by the hour.  For some reason, at 7pm CT, the report goes all zero and it immediately sets to the next day.  It doesn't behave like that in my Desk...
Need Help
southgrad10's avatar
southgrad10
Icon for Helper II rankHelper II
2 years ago

My solution to this issue was to add a Date column to the table in SQL Server.  The Date was simply today's date in DATE format.  e.g. CAST(GETDATE() AS DATE).  I used that date instead of TODAY() in the measures.  It works beautifully.  It has been working great for a week now.