Comment 1 for bug 1846750

Hi mafen,

Are you able to check the database and see if the date is being saved correctly or not?

Please check the "completiondate" column of the "artefact_plans_task" table - is it being saved as previous day at database level?

- if it is then it'll be a read / display at browser level problem

but

- if it isn't then can I get you to check the timezone and offset values on the database.

You'll need to login to the database with the values that the Mahara logs in with

For postgres

you can get the timezone: SELECT current_setting('TIMEZONE');
and offset: SELECT EXTRACT(TIMEZONE FROM now())/3600.0 AS tz_offset;

For mysql

you can get the timezone: SELECT @@global.time_zone, @@session.time_zone;
and offset: SELECT TIMESTAMPDIFF(HOUR, UTC_TIMESTAMP(), NOW()) AS tz_offset;

Cheers

Robert