Hello Mendixer, any advices how to add working days to current Date? is there maybe any Widget like communitycommons just for dates? Datepicker i use : Mendix Marketplace - React DateTimePicker The Usecase: ProjectManager asks you how long you will need for the Task. Your answer is : Min 2 day and max 5 days. Now, i set in a Datepicker the MinTime and MaxTime like in the picture below. Seems to be all fine, in a microflow i set the Attribute MaxTurnaroundTime ( addDays[%currentDateTime$], $Answer1) and Attribute MinTurnaroundTime (addDays[%currentDateTime$], $Answer2). The Problem: The addDays funktion should skip the Weekends. It should add only working days. any advices? I think this should be not a big Problem but i dont found a solution. :-) Best regards
asked
Damir Zenkovic
1 answers
3
Hi,
You can achieve this by adding datetime functions formatDateTime($Date,"EEE").
If it returns 'Sun' or 'Sat' you need to add another day till it is not a weekend . You have to build the logic in microflow accordingly.