Dropdown value changed based on date (Bookings)

Hello All,

I hope someone can help me doing this.. I stuck around 2-3 days to solve this problem..
Below i share my oml about my program,

Here, Car have 2 item which is Car A and Car B.

 I want to create  when the second request  with duration 14:00 until 16:02 already get Car B, then the first request with duration 14:00 until 15:00 will no having dropdown list with item Car B, so i supposed there will be only item Car A..

Very thanks!

I attached my oml , so you can go to screen TrxBookings and Add Booking as user, then you can login as admin and go to TrxBookingsCar screen and try there..

Please help me,
Best Regards,


Hi @Bhetrand Dwilangga ,

I think you need to take a closer look at the join condition you have in the aggregate that provides those values, especially to the first condition, since you're using >= and <=, so you're allowing equal start and end dates.

Hope this helps. Cheers

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.