Page 1 of 1

Clarification on Due Date

Posted: Fri Jun 14, 2019 1:30 am
by jemiris
Hi,
Why the due date is changed to abnormal dates. please look at the below image where the due date has strange. How to solve this problem. :?:
cases.png
cases.png (17.67 KiB) Viewed 5355 times

Re: Clarification on Due Date

Posted: Fri Jun 14, 2019 5:32 pm
by amosbatto
That is bizarre. Is the same value found in the APP_CACHE_VIEW.DEL_TASK_DUE_DATE and APP_DELEGATION.DEL_TASK_DUE_DATE in the database?

You can fix it by changing the values in the APP_CACHE_VIEW.DEL_TASK_DUE_DATE and APP_DELEGATION.DEL_TASK_DUE_DATE fields, but the question is how did you create those datetimes?

Re: Clarification on Due Date

Posted: Fri Jun 14, 2019 5:38 pm
by amosbatto
The case due date is calculated by Calendar::calculateDate(), which is defined in workflow/classes/class.calendar.php in 3.2.1 and earliear or workflow/engine/classes/Calendar.php in 3.2.2 and later.

It takes the calendar, and start date of the task and the expected time in the task properties to calculate the due date, so one of those is the problem. Try changing the calendar to see if that is the problem.

Re: Clarification on Due Date

Posted: Mon Jun 17, 2019 2:34 am
by jemiris
I'm using 3.1 version.
My questions
1. From where the due date comes from :?:
2. Why it changes to the unclear format in case list inbox
3. how to fix that :?:

Re: Clarification on Due Date

Posted: Mon Jun 17, 2019 1:34 pm
by amosbatto
jemiris wrote:1. From where the due date comes from :?:
See my previous post were I explain that. The tricky part is which calendar is selected.
If the user doesn't have a set calendar, then the calendar of the task is used. If the task doesn't have a set calendar, then the calendar of the process is used. If the process doesn't have a set process, then the default calendar is used. For this reason, set a calendar for the user and see if that fixes it.

I have no idea what might have caused the bad calculation of the due date. Maybe you have a bad time in APP_CACHE_VIEW.DEL_INIT_DATE or maybe the calendar is bad or maybe you have a strange value for the expected time to complete in your task properties.

Re: Clarification on Due Date

Posted: Tue Jun 18, 2019 5:14 am
by jemiris
Thanks for the more information. It's strange that didnot affect for all the cases only some cases