Default Date Range vs the custom field date

jenjen1 · 07-11-2024 10:04 AM

Hi I believe Studio is following UTC but I am a bit confused with its time zone.

So this one, I've selected "Yesterday" in the default date range set up side bar of table chart. This shows July 11.

I've checked google now and it is showing July 11 TODAY in UTC. but why does this show July 11 as yesterday when it supposed to be July 10.

I have also created a custom field to show the current date of looker studio and this is what showed up. July 11.

Trying to figure out how really the date control works because it messes up our data when I am using default selection in date control. It will show blank if I selected today to show july 11. And I can't select yesterday as default cause when UTC moves it will show different date again

- Souce Data is from Bigquery and I have July 11 as CURRENT_DATE() today in there

ArkadyZagdan

@jenjen1
you can try to fix at source by converting to exact time zone

for example:

SELECT 
   original,
   DATETIME(original, "America/Los_Angeles") as adjusted FROM

https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#datetime

Regards
Arkady Zagdan
Bigglo.pl