add filter for Date type field

[josescor]

Steps to reproduce the issue

Create a Date type field

Expected result

To create a filter for the front end to search between dates

Actual result

It is not possible from the creation of the component and it must be done manually by modifying the code

System information (as much as possible)

Additional comments

[aDaneInSpain]

I believe this is because we can not rely on the calendar picker being available in the front end, so it would take considerable effort to get implemented.

[josescor]

Hello,
It would be the same case as the Datetime field. Why with this type if it can be done and with the type Date not?
It is only to be able to search between two dates in the filters, not to show the form of entry of data in the frontend.

Another problem I have encountered is that in a Datetime field, using the "user-utc" or "server_utc" filter it is always recorded the date with a previous day but in the form of Joomla articles if it works well.
That's why I tried to use the Data type.

Thanks!
Greetings
Jose

[aDaneInSpain]

OK, let me just get this clear. Are you sating that it is working with a DATETIME field but not with a DATE field? (Both MySQL fields?)

Also the "1 hour before" is related with the server time zone and Joomla and is not related with Component Creator. You can read more about it here.

https://issues.joomla.org/tracker/joomla-cms/5954

[josescor]

Yes, I know this thread about the dates in Joomla.
The problem is that it records a day earlier, not an hour, and this only happens in the form created with CC, not with Joomla articles, so there is something different between the two components.

I'm working with a MySQL Date type field but since I could not define a filter in CC, I did tests with the DateTime but what I need is a field only with the format AAAA-MM-DD.

Thanks
Jose

[aDaneInSpain]

Hi Jose, this is strange.

I suppose that you mean YYYY-MM-DD and not AAAA ?

Also, can you please tell me the email you are using to log-into Component Creator and the name of the component that has this issue (as well as the table and field).

You can email that to support@component-creator.com if you are uncomfortable posting it here.

[josescor]

Hello,
sorry, yes, I meant YYYY, (I speak Spanish and my English is a little bad).
I send the requested information by private mail.
Thanks!
Greetings
Jose

[aDaneInSpain]

Bueno, también hablamos en español :-)

[josescor]

Gracias pués, lo escribo en español, para no crear más confusiones.
Saludos