• Resolved LMTT Design

    (@lmtt)


    Hi!
    We’ve stumbled upon a problem and would like your help to solve it.

    The shortcode work as intended, but when displaying dates for the event list, for some reason it uses the default UTC time instead of the timezone set on WordPress.

    We’ve already checked the current WordPress and Google Calendar timezones and both are correctly set to UTC/GMT -3 hours (Sao Paulo).

    Thanks in advance!

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author kimipooh

    (@kimipooh)

    Does that mean we’ll be off by three hours?
    Firstly, please try to set UTC-3(Manual Offsets) instead of Sao Paulo.

    I experimented with this at hand and found the following on WordPress 5.8.2.

    Ex.1
    Server Timezone: UTC+0
    Google Calendar:
    Timezone: UTC-3 Sao Paulo
    Event: 17 November, 2021 10:30 – 12:00
    WordPress: Timezone: Sao Paulo (UTC-3)

    date_format in this plugin shortcode
    d-m-Y H:i:S

    Display is 17-11-2021 10:30:00

    Ex.2
    Server Timezone: UTC+0
    Google Calendar:
    Timezone: UTC+9 Tokyo/Asia
    Event: 17 November, 2021 10:30 – 12:00
    WordPress: Timezone: Sao Paulo (UTC-3)

    date_format in this plugin shortcode
    d-m-Y H:i:S

    Display is 17-11-2021 22:30:00

    These cases is correct.

    Thread Starter LMTT Design

    (@lmtt)

    Hello! First of all, thank you for your reply!
    Since we’re using CPanel, we changed the server timezone through php.ini.

    Here’s what our PHP file looks like:
    date.timezone = “America/Sao_Paulo” (set following the supported timezones rules)

    Here’s the timezone we’ve set on WordPress:
    UTC-3 (also tried “America/Sao Paulo”, but it didn’t work)

    The WordPress date example we got was:
    universal time: 2021/11/18 03:19:37
    local time: 2021/11/18 00:19:37

    On Google Calendar, the timezone is:
    America/Sao_Paulo

    Our shortcode looks like this:
    [gc_list_view orderbysort=”ascending” date_format=’d/m/Y’]

    The final result is:
    07/11/2021 (ie. 2021/11/07)

    It should be:
    08/11/2021 (ie. 2021/11/08)

    Is there anything else we can do?

    Currently using:
    Google Calendar List View 6.5.2
    WordPress 5.8.2

    Plugin Author kimipooh

    (@kimipooh)

    What is the value if you set the time format?

    [gc_list_view orderbysort=”ascending” date_format=’d/m/Y H:i:S’]

    In my environment,

    Here’s what our PHP file looks like:
    date.timezone = “America/Sao_Paulo”

    Here’s the timezone we’ve set on WordPress:
    UTC-3 or “Sao Paulo”

    The WordPress date example we got was:
    universal time: 2021/11/18 07:53:09
    local time: 2021/11/18 04:53:09

    On Google Calendar, the timezone is:
    (GMT-03:00) Brasilia Standard Time – Sao Paulo
    10:30 – 12:00
    * My Local timezone is JST (UTC+9)

    ===
    When I set 10:30 – 12:00 set timezone is Brasillia Standard Time – Sao Paulo (GMT-3), Google Calendar shows it as 22:30 – 0:00 because my time zone is UTC+9 (Tokyo/Japan).
    And in WordPress, it shows up as 10:30:00. This means that the Google Calendar is not displaying the correct date.
    If you set the Display secondary time zone to Brasillia Standard Time – Sao Paulo in the Google Calendar settings, the time became to be displayed as 10:30:00 in Google Calendar as well.

    So, does the time displayed in Google Calendar match the date and time displayed in the detail view (event edit screen)?

    Thread Starter LMTT Design

    (@lmtt)

    Hello again!

    Changing our shortcode to:
    [gc_list_view orderbysort=”ascending” date_format='d/m/Y H:i:S']

    That’s the result we got:

    Event I 21/11/2021 21:00:st
    Event II 21/11/2021 21:00:st
    Event III 23/11/2021 21:00:rd
    Event IV 24/11/2021 21:00:th

    All those events lasts all day long.

    Our local timezone (system timezone?) is: UTC-03:00 Brasília
    (choosen automatically and there isn’t a “Sao Paulo” option)

    That’s the website in question:
    https://monteirolobatosp.com/

    Here’s a page where you can see another calendar plugin working properly:
    https://monteirolobatosp.com/calendario/

    Plugin Author kimipooh

    (@kimipooh)

    I cannot find out why the time is wrong. So, I added the new function to shift the hours, minutes, and seconds by setting the value of “Fix Timezone Offset” in this plugin setting menu. Please update this plugin to version 6.6 and set Set the value of “Fix Timezone Offset” in this plugin setting menu.

    If you want to shift the time to -3 hours, set the value “-3 hours”.

    Thread Starter LMTT Design

    (@lmtt)

    Thank you so much for the help and the amazing support!
    Coding a specific solution for our case was really unexpected, and we can’t thank you enough for all the attention and support you gave us!

    Rating it 5 stars and marking this as solved!
    Thank you so much!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Shortcode Displaying Wrong Dates (UTC Issue)’ is closed to new replies.