Publicado Thu, 13 Dec 2018 20:43:45 GMT por Nathan French ComDoc Systems Analyst

I'm stumped by an odd thing with dates in workflow, with an on-premise system that was just upgraded to 7.0.  This is a new workflow, so I'm not sure if the upgrade had anything to do with it.  

- I'm using WF_CURRENT_DATE to datestamp an approval.  It is always showing yesterday at 5pm.  
I
n my cloud system WF_CURRENT_DATE always shows today at noon.  
(I know the time is not part of WF_CURRENT_DATE, no problem. But being recorded as 5pm instead of noon is odd)

- I'm pulling a date field to prefill a task form field, and it decrements the already indexed date by one day.
Indexed field:  Date = 12/13/2018
Form: (Prefill: Index Data; Field: Date) = 12/12/2018

Examined so far:
- System times and timezone (US Eastern Standard, UTC -05:00) are correct on DW server, DB server, Client machine.
- All other date fields in DW are correct: Stored, modified, document history items, even workflow history items.  And the 'x' shortcut for current date.
- Returned value is off by -19 hours.
 - - Actual returned: "12/12/2018 5:00:00 PM" 
 - - Expected correct: "12/13/2018 12:00:00 PM"

I did put in a service request, but if there's a file somewhere to change a number in and someone knows it, this may be faster.

Thanks in advance.

Publicado Fri, 14 Dec 2018 11:46:00 GMT por Phil Robson DocuWare Corporation Senior Director Client Services, Americas

Nathan,
Support have at least 2 open issues with R&D on workflow dates. The problem is that UTC offset is being applied to a date only value when it should not be.
 

 

Phil Robson
Senior Director Support DocuWare

Publicado Tue, 02 Apr 2019 17:24:54 GMT por Matthew Trembly Software Support Manager
It appears this was resolved in DocuWare Version 7 Minor Update 20190118 / Build (file) version: 7.0.0.8559 / Setup version: 7.0.8558.0

Are you able to confirm?

 
Publicado Tue, 04 Feb 2020 23:15:16 GMT por Nathan French ComDoc Systems Analyst
The previous behaviors from my original post are no longer present:
- dates are not being decremented when they are read from.
- WF_CURRENT_DATE reports 12pm now and not 5pm.

Now I'm seeing some different odd behavior, but it feels very related.  This is Build 7.1.0.15390 (2019-12-09)

Right now, I'm trying to add 7 days to WF_CURRENT_DATE.   
  • Before 5pm, it adds 6 days.  (Feb 4 + 7 days = Feb 10)
  • After 5pm, it adds 7 days.  (Feb 4 + 7 days = Feb 11)

I'm in EST (UTC-5) so it looks like I'm seeing the same "off by -19 hours" error as I did before. 
24 hours - 5 hours = 19 hours so i'm guessing the UTC-5 offset is involved.

Right now, it's not an actual problem for what I'm doing.  I'll just add 8 days, and it will wind up being 7 days for stuff processed within normal business hours, which is when this scheduled workflow runs.  It's easy enough to envision scenarios where this would cause trouble though.

If this is one of the fixes in 20200107, it's not listed.
 
Publicado Tue, 04 Feb 2020 23:23:35 GMT por Phil Robson DocuWare Corporation Senior Director Client Services, Americas

Oh dear. Nathan, please report it to support.

Phil.

Publicado Tue, 04 Feb 2020 23:27:27 GMT por Phil Robson DocuWare Corporation Senior Director Client Services, Americas
Nathan,
Please confirm that the DocuWare System Time Zone is correct as EST in DocuWare Administration - just in case....

Phil
Publicado Wed, 05 Feb 2020 14:41:02 GMT por Nathan French ComDoc Systems Analyst
Thanks Phil.  
I confirmed the time zone is "(UTC-5) Eastern Time (US & Canada)"

You say "Oh dear" so I'll put in a support ticket after I gather some screenshots before and after 5pm today.

Nate

You must be signed in to post in this forum.