Thread

Using just the basic commands for the calendar, I’m getting a significant glitch, the event it’s displaying is off by a whole day.
I dare not go near timezones etc but as you’ll see in the image the actual entry it represents displays correctly… whats up wit dat ?

Before one asks, EEE 2.1 Build:  20100810, heaps of modules but none dealing with dates

Hi, Cheif. Have you considered upgrading to EE2.1.1? There were some fixes involving time, but do you still have DST turned on? Was it turned on when the entry was made?

OK, So i have upgraded the system to 2.1.1 and the dates are still off.

I’ve placed the article entry date in the calendar to ensure it’s reading correctly.

{exp:channel:calendar switch="calendarToday|calendarCell" channel="events" show_future_entries="yes" show_expired="yes"}

<table class="calendarBG" border="0" cellpadding="0" cellspacing="0" summary="My Calendar" width="100%">
    <tr class="calendarHeader">
        <th><div class="calendarMonthLinks"><a href="http://{previous_path=events}"><<</a></div></th>
        <th colspan="5">{date format="%F %Y"}</th>
        <th><div class="calendarMonthLinks"><a href="http://{next_path=events}class=calendarMonthLinks">>></a></div></th>
    </tr>
    <tr>
    {calendar_heading}
        <td class="calendarDayHeading">{lang:weekday_abrev}</td>
    {/calendar_heading}
    </tr>
    
    {calendar_rows }
    {row_start}<tr>{/row_start}
    
    {if entries}
        <td class='{switch}' align='center'>
        {entries}
        <div><a href="http://{title_permalink=events/item}">{title}{entry_date format="%d %F %Y %g:%i"}</a></div>
        {/entries}
        </td>
    {/if}
    
    {if not_entries}
        <td class='{switch}' align='center'>{day_number}</td>
    {/if}
    
    {if blank}
        <td class='calendarBlank'>{day_number}</td>
    {/if}
    
    {row_end}</tr>{/row_end}
    {/calendar_rows}
</table>
{/exp:channel:calendar}

This is pretty much verbatim of the example code, site launch is imminent but this one will hold it back. Logins handed out where required.

Does this only affect the calendar, i.e. is it working on the rest of the site? When you change the entry time to, say, noon, does that change anything?

If I use time: 25th Dec. 12.00 it shows fine in the calendar (ie on the 25th) but as soon as I use 25th Dec. 13.00 it jumps to the next day (26 Dec.)... does this mean my server offset time should be 12 hours ?

Server time has been checked via info, time zone is correct, time is correct… NFI now !

What timezone are you in? Do the entries as such have the correct time format, i.e. when displayed via a template instead of the calendar?

Server is in AUS showing AEST, profile is set to AEST… the date “displays” correctly everywhere (see previous screen grabs) when using {entry_date} even in the calendar.
The calendar itself displays the contents exactly as recorded; just places it in the future for any entry that has an {entry_date} between 13.00 - 23.59 using any other time 0.00 - 12.59 works as expected and displayed on the correct calendar day.

Hi Cheif,

What do you have set for the server default timezone at Admin > Localization settings? Is that what you meant by “Server is in AUS showing AEST”?

Cheers

Greg

Sorry UTC+10 (Aust. Eastern Standard Time) is the default time zone (in CP) and the same time zone as the hosting server. This one has me miffed.

Cheif,

Under your account what do you have set for your own Localization settings.

try this inside a template to return some useful troubleshooting information

<h1>Test of various time/date functions:</h1> 

<h2>Server</h2><p> <br />
PHP date: <?php echo date('dMy h:i');?><br />
 <br />
PHP gmdate: <?php echo gmdate('dMy h:i');?><br />
 </p>

<h2>Database dates(GMT/UTC)</h2><p> <br />
LOC now: <?php  echo 'held in db as '.$this->EE->localize->set_localized_time(); echo ' which is '.date('d My h:i',$this->EE->localize->set_localized_time()); ?> <br />
 </p>

<h2>User</h2><p> <br />
Users timezone: <?php echo $this->EE->session->userdata['timezone'] ; ?><br />
 <br />
Users Time:<?php echo $this->EE->localize->set_human_time(); ?>

I can see the database time is out but NFI what I’m really looking @.

http://dea.beanstalkcreative.com.au/test

Hi Cheif,

As John Henry suggested double-check your own user localization settings by clicking Control Panel in the sidebar and then clicking Localization Settings on the left. Do the times change if you view the template when logged out?

NO, both times remain constant. Can you explain what the times I’m seeing are ?
I can see one of the dates is is calendar day ahead but NFI what it’s referring too ?

Have you run the code John Henry provided? Could you please paste the result here?

Test of various time/date functions:
Server
PHP date: 08Dec10 08:28
PHP gmdate: 07Dec10 09:28
Database dates(GMT/UTC)
LOC now: held in db as 1291791535 which is 08 Dec10 05:58
User
Users timezone: UP95
Users Time:2010-12-08 06:58