Hi, as suggested in the comments the page Using Date Formatter, Date Filter and Date Range Filter might be helpful.

Dear Mister/ Madam,

Thank you for your answers.

I have used the (yyyy/MM/dd) data-format, because the (dd/MM/yyyy) does not work properly when sorting the list (since it sorts the list based on the date first).
So I have used the (dd/MM/yyyy) as a display-format, but the workflow variable of the date picker, takes the data-format (not the display-format) and as a result the deadlines are not working properly.

I can implement the suggested solution, only if there is a way to sort a (dd/MM/yyyy) format based on the year first.

Best regards

I have used the (yyyy/MM/dd) data-format, because the (dd/MM/yyyy) does not work properly when sorting the list (since it sorts the list based on the date first).

So I have used the (dd/MM/yyyy) as a display-format, but the workflow variable of the date picker, takes the data-format (not the display-format) and as a result the deadlines are not working properly.

 

I can implement the suggested solution, only if there is a way to sort a (dd/MM/yyyy) format based on the year first.

Change the format just before you pass it to the deadline.

1. Get the Date Formatter plugin https://marketplace.joget.org/jw/web/userview/mp/mpp/_/vad?id=date_formatter_hash_variable-1

2. Put a Tool before the activity with deadline inside in process builder.

3. Map the tool to Bean Shell Tool.

4. Enter the code into it.
   Change this code accordingly. In this code, the workflow variable "timer" holds yyyy-MM-dd value.
   It will be changed to dd-MM-yyyy and set back into itself.
   (In your case, change "timer" to "returnDate2")

   import org.joget.workflow.model.service.*;
    
   WorkflowManager wm = (WorkflowManager) pluginManager.getBean("workflowManager");
   wm.activityVariable(workflowAssignment.getActivityId(),"timer", " #dateFormatter..yyyy-MM-dd&dd/MM/yyyy#");