Date element inserted 23:20:00

[railer]

I have a job listing site which is running on Joomla 3.8.x and Fabrik 3.8.1.
Can't upgrade at the moment as it is a JMS Multisite.

We have built a Job Listing database managed with Fabrik.

Issue:

When an Employer posts fills out the job description, there is a Date field element called Publish Date. For some strange reason, when a recent job was posted, it saved the time associated with the date in the database as 23:20:00. Which meant that when the publish date came around, the job wasn't visible until almost midnight.

Do you have any suggestions as to how to overcome this problem so that when the date changes, the time will be 00:01:00, or something with the same effect? I suppose that 00:00:00 would be the start of the next day.

 

[cheesegrits]

Which date element and what are the settings for time and formats?

-- hugh

 

[railer]

Hi Hugh,

I've uploaded two screen captures of the "date" element's settings. Note that server time was set to PDT when the issue was noticed. I've since reset it to EDT (our local time) and have rebooted the server. PDT is 3 hours behind EDT. But I don't think this issue is related. Again, this is Fabrik 3.8.1. (Joomla 3.8.8.).

 

[marozen]

In the list and form format field (your first photo) you can set in what format you want. The following link will help:

https://www.php.net/manual/en/function.date.php

 

[cheesegrits]

If you turn the time selector on, it should save the current time.

-- hugh

 

[railer]

If you turn the time selector on, it should save the current time.

-- hugh

Thanks Hugh and marozen. I had already set the time selector to Show after I took the screen capture. Waiting to see whether the time is accurate. However, I don't understand why the time value wouldn't just default to 00:00:00 if nothing else was configured? More strangely, where the heck did the 23:20:00 value which was stored in the database come from? Is it based on the time at which the PayPal IPN came through? Weird!

 

[cheesegrits]

I have no idea where that time came from.

I don't think a PayPal IPN would effect it, unless you have some custom code set to update that date element. We very explicitly only update the fields you specify in the IPN handling.

-- hugh

 

[railer]

Okay. Well I plan to upgrade the sites and Fabrik in the next couple of weeks. We'll see if these problems resolve themselves. Hopefully there won't be any new problems. Speaking of which, is there anything I need to be aware of which might break when going from Fabrik 3.8.1 to 3.9? In hindsight, I don't really want the "time selector" to be on.
Can you please confirm what "time" the date element ought to be saving into the database along with the chosen date if the time selector is off?

 

[cheesegrits]

It should save 00:00:00 with the time selector off. Well, if the element is set to save UTC, it'll apply your TZ offset to that.

I'm not aware of anything breaking between 3.8.1 and 3.9. Although there have been a lot of changes since then, it's mostly small, incremental stuff. New features, bug fixes.

You may need to work on your date elements, I can't remember when I made the changes that introduced the new jdate element, and changed the time selector on the 'date' element.

-- hugh