Date format

Hi,
I use Joomla 5 in German regionalization, especially date format is "dd.mm.yyyy" in Joomla. So in Membership pro I selected Date format to be "d.m.Y". 
Two issues with that:
- Creating a subscription for an existing user results in a custom field of type "date", field mapping to Joomla's profile field "dob" the format "yyyy-mm-dd" which fails then at saving because of the format differing from "d.m.Y".
- The expired date in a subscription plan, selected by the calendar icon ort entered manually, is not saved at all in the database.

Are these bugs or am I doing something wrong?
THX,
Robert

Hi Robert

- Shouldn't the dbo field uses the same date format ?
- The expired date in the plan should be saved. Maybe it is not saving because the plan is a recurring subscription plan? You cannot have a fixed expiration date for recurring subscription plan

Regards,

Tuan

Hi,
- it is on the frontend. In the database it is saved in the "base" format having "yyyy-mm-dd". So IMO conversion is missing in membership pro. See attachments.
- Argh, doesn't this make sense especially for recurring subscriptions? I want them to be renewed at 1st of January each year, therefore the first subscription has to end on 31st of December. The first subscription could then be part time, the user only pays only the rest of the year (prorated subscription). Also in the doc of "Expired date" there is no hint that it doesn't work for recurring subscription. What is the reason for this and what happens, if I set the date directly in database? At a first glance, it seems to work.....
Thanks for your support,
Robert

Hi Robert

1. The extension just pass the data to user profile as how it is. It is not aware of the expected format of certain custom field

2. I can only say that it is hard to implement that for recurring subscription

Regards,

Tuan

Hi Tuan,

unsure if I understand you correctly regarding the first point - "dob" is a regular Joomla profile field of type "date", not a custom field created by me. In membership pro indeed I created a custom field of type "date" linked to the Joomla profile field "dob".
If I now - as an admin in the backend - create a subscription selecting first the plan and then an existing (Joomla) user, the "dob" is fetched 1:1 from the Joomla profile (or database, I don't know) and then has the wrong format compared to the setting in membership pro config, so that the subscription cannot be saved/applied, because another date format is expected by membership pro.

THX,
Robert
 

That's correct. But the system allow mapping with all kind of fields, it just get data store in the field (as how it is) to pre-populate the subscription data and it could not have special handling with data from dob field

Anyway, I would say user profile is the old way to store custom data for users. These days you should user custom fields instead because Joomla now allows you to create custom fields to store user data

Tuan

Hi Tuan,

I simplified the situation a bit - I simply created a custom field of type "date" in membership pro - nothing else. As a result, in the table listing the subscriptions, the date is displayed without respecting the config value (d.m.y), whereas the creation date and the start/end date are displayed correctly. (see attachment)
So I assume, that custom date fields ignore the date format config values at all.
Additionally, but minor, the tooltip regarding the format is also wrong - it expects "d.m.Y" in the field according to configuration, but shows "y-m-d" as required. (see attachment)
For the moment, I will reset the config values to "y-m-d" to gain the functionality at the price of being beautiful
Would be glad, if those issues could be fixed somewhere in the future.
Regards,
Robert
 

Hi Robert

I will check. At least the date displayed in subscriptions list should respect the configuration. I will check it when I come back from new year holiday (we are having new year holiday in our country (and other Asia countries) these days, so we for the less important issue, we will delay fixing it)

Regards,

Tuan