Hi sasank,
If I understand the issue, I present some insights, and potential solutions:
Create a Microflow:
Check Shift Timing:
parseDateTime
function to convert the times to datetime objects for easier comparison.Example (pseudo-code):
if (parseDateTime($startDate) >= parseDateTime('6:00 AM') && parseDateTime($endDate) <= parseDateTime('10:00 PM')) { // Dates are within the shift time range // Continue with further logic } else { // Show an error message or handle it as per your requirement }
Calculate Working Hours:
Example (pseudo-code):
$totalHours = 16; // Total hours in a day $firstShiftHours = 8; // Hours for the first shift $secondShiftHours = 8; // Hours for the second shift
Display Error or Proceed:
This is a basic outline, and the actual implementation may vary based on your specific use case and data model. Adjust the code accordingly, considering the data types and attributes in your Mendix application.
** Kindly accept my answer if it assist you to solve your problem.