× Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues

Change format of Calendar (J_Calendar)

Nick Gardei

New Member

Posts: 10

9 years 7 months ago #690 by Nick Gardei

Replied by Nick Gardei on topic Change format of Calendar (J_Calendar)

Long story short is this;

Even after changing the preg_match to validate (return true) for my date format the search still fails.

There is yet another place where the preg_match needs to line up - inside the getListQuery() function in the same file.

//Checking "_dateformat"
      $filter_date_from = $this->state->get("filter.date_from_dateformat");
      if ($filter_date_from && preg_match("/^(19|20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$/", $filter_date_from) && date_create($filter_date_from) ) {
         $query->where("a.date >= '".$db->escape($filter_date_from)."'");
      }

However this STILL won't work because the data is stored in the table in YYYY-MM-DD format.

Ugh....frustrating for something so simple. I've literally wasted 6 hours so far on this one tiny detail.

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

Russell English

Junior Member

Posts: 21

9 years 7 months ago - 9 years 7 months ago #691 by Russell English

Replied by Russell English on topic Change format of Calendar (J_Calendar)

Hi Nick, I'm glad it's not just me that was having difficulty with this.

Changing the date format should be a simple procedure and should be managed with a Language override within the CMS itself (as many other components and Joomla itself do).

Thanks for the updates though and for keeping me in the loop.

Last edit: 9 years 7 months ago by Russell English.

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

Søren Beck Jensen

Administrator

Posts: 81

9 years 7 months ago #694 by Søren Beck Jensen

Replied by Søren Beck Jensen on topic Change format of Calendar (J_Calendar)

We are looking into the COM_PRUEBA issue and I am happy to report that it looks like someone will be buying "f**k up beer" this Friday, which is tradition when someone makes a stupid mistake in our company. If you are in or around Granada, Spain you are invited.

In relation to making it easier to change the date format, then we will investigate what we can do to make this easier to do.

Søren Beck Jensen
Founder, Component-Creator.com

The following user(s) said Thank You: Russell English

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

Russell English

Junior Member

Posts: 21

9 years 6 months ago #790 by Russell English

Replied by Russell English on topic Change format of Calendar (J_Calendar)

Hi Søren, is there any update on this please?

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

Søren Beck Jensen

Administrator

Posts: 81

9 years 6 months ago #791 by Søren Beck Jensen

Replied by Søren Beck Jensen on topic Change format of Calendar (J_Calendar)

We fixed the COM_PRUEBA issue immediately. Is that what you are having problems with or are you talking about the date format issue?

Søren Beck Jensen
Founder, Component-Creator.com

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

Russell English

Junior Member

Posts: 21

9 years 6 months ago #792 by Russell English

Replied by Russell English on topic Change format of Calendar (J_Calendar)

Thanks Søren, talking about the date format issue

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

Time to create page: 0.055 seconds