How do I check whether a date matches another record on save?
Hi, New to Mendix, I need to check that when adding a record to a table that the date entered on the record matches a specific date in another table. Any suggestions on how and where I would do this in a microflow, I have some ideas on teh microflow but not entirely sure where to trigger the event etc. Thanks in advance of any help. Regards Nick Ford
You can use before commit event on first Object which will return Boolean ,so make it return true to be committed successfully otherwise false .and you can compare date rather than datetime as follows,
trimToDays($object1/Date)= trimToDays($object2/Date) which means that this date match the other date