[NAlvarado]

I'm trying to capture the time and date a user takes action via a trigger. I am using $date = date("Y-m-d H:i:s") the date is correct but the time is off by a few hours (forward). Any suggestions to get it to display the correct time?

[amosbatto]

You have a difference between the time zone of the server where ProcessMaker is installed and the time zone of the local computer where the web browser is accessing ProcessMaker.

If all your users are in the same time zone, then change the time zone of your server to that time zone. You need to change the time zone of your server (you can use the "date" command in Linux), then change the date.timezone in your server's php.ini file and also set time_zone ="X" in your env.ini file.

If all of that is too complicated, then just use JavaScript to set a hidden field in a Dynaform.
Create a datetime field associated with the "currentTime" variable.
Then use this JavaScript code to set it:

Code: Select all

var formId = $("form").prop("id");
$("#"+formId).setOnSubmit( function() {
   var now = moment().format("YYYY-MM-DD HH:mm:ss");
   $("#currentTime").setValue(now);
});

Then, you can use it in a subsequent trigger as @@currentTime. You know that it will be the current time when the dynaform was submitted according to the user's local computer.

[NAlvarado]

I tired the javascript route and the time shows as 14:29 even though my desktop shows 9:30 am. I checked the php information and the timezone is set to UTC. I will ask the DBA to update to America/Chicago in the php.ini file. Thanks!

[NAlvarado]

DBA changed the php.ini file and the timezone is now set the same as environment. However, I noticed in PHP Information page, that Local still shows UTC while Master shows America/Chicago. What is the best way to get this updated to America/Chicago so that the time reads correctly?

[amosbatto]

Laravel which is used in PM 3.2.2 and later always sets the default time zone to UTC. The developers insist that this is the way it is supposed to work.

If you want to change the default time zone, see:
viewtopic.php?f=40&t=730768&p=816173#p815356

If you are using the Enterprise Edition, it automatically adjusts the time in datetime fields for the timezone, which may be screwing up things for you. Use a hidden field instead of a datetime field to store the "currentTime" variable, if you are going to use JavaScript.