Different date information on the form archive and in the follow up form

[marinam]

Hello,

We noticed that follow up form is showing different date from date entered in the form (1 day ahead).
Data element is Date/Time data type, Culture is User’s Culture, TimeZone is Arizona.

Could you please help us to resolve this issue?
Thank you in advance,
Marina Stefanovic

[eddy.daouk]

Hi @marinam,

I believe your issue is related to this:

Form designer: How to display GMT dates

In WorkflowGen, datetime data iare stored with the GMT timezone in the WorkflowGen database. By default datetime data are converted to the user’s timezone and displayed with the user’s culture in the web form and the User Portal. If you want to display the datetime data in GMT, follow the procedure below (available since version 5.5.1). 1. In the Form Designer For the corresponding fields containing the dates, add the TimeZoneConversion custom attribute with the value false. 2. In the Admini…

Let me know if this helps,
Eddy.

[marinam]

Thank you @eddy.daouk. I implemented time zone change (set GMT for data element) and added custom attribute for the field. Now it is working well, it is showing the same info in the follow up form and in the form archive.
But now another issue appeared. Lead time of the activities is set by that data element. And now, time limits of these activities in the follow up form are set one day BEFORE date listed in the field. And it should be on that date, not day before. Is there any resolution on that?

Thank you,
Marina

[eddy.daouk]

Hi @marinam,

I would create a hidden Date field that adds one day to the indicated GMT day (in code behind) and use that new data as a Lead time.

DateTime.AddDays(Double) Method (System)

Regards,
Eddy.

[marinam]

Thank you Eddy. I managed to resolve the issue.

[marinam]

Hi @eddy.daouk,
I’m contacting you again because of the similar issue.
We have the problem how date/time is presented in different time zones again.
We didn’t implement your suggestion from the article above.
My colleague has user settings Arizona, the date and time (both data elements have TimeZone Arizona) he sees in the follow up form is correct, but when he opens request, he sees one day before (please see screenshots). Is there any other setup that has to be updated in order for this to work? Our company works in two time zones - GMT+1 (Belgrade), and GMT-7 (Arizona).
I found this article, it explains similar issue like we have:

How can I set a datetime value for form data in code-behind with the consideration of user time zone and Daylight Saving time?

Background WorkflowGen will automatically take the date value entered by user from a DateTime text field on a web form and add the proper value to the FormData. However, if a date is set manually in code-behind, by default the date will not have the time zone factor and it will cause a date issue. For example, May 1, 2019 (2019-05-01) will become 2019-05-01T00:00:00 in the WorkflowGen form data. When this value is passed to WorkflowGen process data, if the time zone is Eastern US & Canada time,…

Could this maybe resolve the problem?
Could you please help us to resolve this issue?
Thank you!
Marina

[eddy.daouk]

Hi @marinam,

Is the date entered manually in the form or calculated in code behind?

Eddy.

[marinam]

@eddy.daouk, date is entered manually in the form. When requester open new Termination request, he is manually entering the date and the time of the employee termination. Hope this answers your question.

Thank you,
Marina