Default date element time to 00:00:00

[jo-ka]

Hello.

I understand that the element Date is in fact a datetime database field. When using the date element to select a date, even if I have no time selection, the date value always returns the time with the current time.

Is there a way to set an element property to always have the time like 00:00:00?

I'll need this because I need to filter the fields based on dates and sometimes the results are incorrect because of this time.

A solution could be manually set the database field type to date, but every time we make a change to the date element, the database field is automatically updated to datetime again.



Any suggestion?

Thanks in advance.

 

[troester]

Did you try with
default (eval) = return date('Y-m-d 00:00:00');
and Time selector =off
This should store all dates with time 00:00:00

Maybe you have to set Date format = local time, too.
I didn't test which date is stored if you are storing the date e.g. at 1am (where UTC is still one day behind).

 

[jo-ka]

Dear Troester,
The date was already set up to Local time.

Your approach is OK, and probably I'll need to set it like this.
I would prefer not to have a predefined date, but if this is the only option, I can live with it.

Thanks.

 

[troester]

You don't need a default (I thought you wanted one).
Set time selector off (and no time format for forms).

 

[jo-ka]

I've tried that before, I think that I'm setting the correct option, but I can't clean the Time Format, it maintains always the H:i format.

Am I doing something wrong?

View attachment 17119

 

[troester]

Ah, not this one.
View attachment 17120

 

[jo-ka]

There's nothing there also...

View attachment 17121

 

[troester]

hmmm, and it's still showing times <> 00:00 in new records?
I assume in existing records it may be necessary to set the time to 00:00 manually (e.g. phpmyadmin)

 

[jo-ka]

Exactly, this is what is going to the database:

View attachment 17124

View attachment 17125

But, if you click on the elements fields, on any empty space before submit the form, then it will take 00:00:00

View attachment 17126


After clicking on the empty space...

View attachment 17127

View attachment 17128

Isn't this strange?

 

[jo-ka]

Friendly bump...

 

[troester]

I can't replicate.
On my site it doesn't show any time before or after clicking into the date field (with form date format = d-m-Y)
(and saving an existing record which had a time set before the time is set to 00:00 after save).

Did you clear Joomla and browser cache?
Which exact Joomla and Fabrik?