Forum Discussion
Email Subscriptions: Time Zone issue?
Hi rsbin ,
It might be the UCT time issue, but I just don't think so. One way to confirm/deny it is to put the date and time of the last refresh on the report and see what is happening. Put it in both local (EST) and UCT time.
But, I would suspect that the refresh itself is taking too long or not starting when you think it does. I would look at the refresh log for the report and see what time is starts and what time it finishes. I can see where if it doesn't finish until after 12:00 that you have crossed a "date line" and then the report might calculate an unexpected date.
AND, do you know for absolute fact that the data source you are using is in the same timezone as you? Maybe your report is refreshing quickly and at 11 EST but your data source is ahead of you or just not updated yet?
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Good Morning collinq
Thank you for the response. I tried a simple test last evening. At 7:30 pm Eastern I performed a "Run Now" and the date was correct. At 10:30 pm, I performed another Run Now and the date did roll over to Oct 30.
I appreciate your ideas of putting a Refresh date and time to gain further insights. I do this on most of my other reports, but haven't done it on this one just yet. This is a small report so the refresh takes only 5 - 10 minutes.
My data source is in an Azure database. Now that I think about it, when an Audit gets posted from our App to the database, it gets registered as UTC time. I do some manipulation in Power Query to add a column to convert the time back to the Local Time where the audit was performed. Will do some additional testing this weekend.
Again, thanks kindly for your thoughts, suggestions and advice.
Best Regards,