Forum Discussion

ryan87's avatar
ryan87
Regular Visitor
8 years ago

UTCNOW() incorrect on web version

Hi,   I have a report which has a visual that shows when the report last refreshed by using the UTCNOW() function. However since the daylight savings changed by 1 hour, the time on the web version ...
Need Help
v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi ryan87,

 

What's the Time Zone setting on your local machine? And why did you make the daylight savings changed by 1 hour? Could you please make a more detailed description about your issue? So that I can make some proper tests.

 

Thanks,
Xi Jin.

ryan87's avatar
ryan87
Regular Visitor
8 years ago

Hi v-xjiin-msft, jthomson,

 

I haven't changed anything, the physical time changed by 1 hour due to daylight saving and since that, the time on the web version of the reports has been 1 hour in the past, so it clearly looking at the wrong time. The time for the same visual on the desktop is correct, so I don't think it anything to do with my time settings on my desktop (below).

 

Machine settings: Time Zone (UTC+00:00) Dublin, Edinburgh, Lisbon, London

 

I have just checked and my machine settings are exactly the same as the Time zone settings of the scheduled refresh, whcih is taking place on time. However the visual with UTCNOW() is incorrect.

 

It's now 11.55am so as per below, the last refresh took place at 11:00am which took 9 minutes, but the visual on the report says 10:09 as below.

 

Any other suggestions would be appreciated.

 

 

 

Thanks