Subscription Renewal Record End Date does not Match Previous Start Date

  • Elliot Block
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
7 months 3 weeks ago #156004 by Elliot Block

I have a question about subscription records and what should happen when a renewal occurs.

In our case, we have a plan with:

Subscription Length: 1 year
Enable Renewal: Yes

When I renew my own membership (for next year) as a test, the start date (GUI) is 12/31/2023 16:00:00 and the subscription end date (GUI) is 12/31/2024 23:59:59.

The values for the subscription record in the database are:
from_date (database): 2024-01-01 00:00:00
to_date (database): 2025-01-01 07:59:59

Why is the membership record start date (GUI) not 1/1/2024 00:00:00 [or from_date (database) 2024-01-01 08:00:00]?
Incidentally, we are in the UTC-8 time zone (the Global Configuration for Joomla is set to "Los Angeles").

Is there something I forgot to setup? It would be nice for the records to be appropriately aligned with one another.


Please Log in or Create an account to join the conversation.

7 months 3 weeks ago #156006 by Tuan Pham Ngoc
It is something with timezone handling here. Basically, the data stored in database is in UTC timezone, while the value displayed in GUI is using your site timezone

I guess the issue happens here is because the end date of the previous subscription record stored in database is 2023-12-31 23:59:59, so the start date of the renewal record is 2024-01-01 00:00:00

I will have to check and make sure 2023-12-31 23:59:59 is saved to the database with right value (2023-12-31 15:59:59) since your site timezone is GMT - 8 and it will address the concern

Will update you if I figured out something


Please Log in or Create an account to join the conversation.