WF_CURRENT_DATE is showing yesterday at 5pm.-1544737425

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.  
In 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.

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

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?

 

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.
 

Oh dear. Nathan, please report it to support.

Phil.

Nathan,
Please confirm that the DocuWare System Time Zone is correct as EST in DocuWare Administration - just in case....

Phil

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