@PirtekKH
I’ve had a similar request in the past if a request was created in the evening for a specific customer. I couldn’t seem to find the correct format of expressions to enable this to work. Therefore I did it with a few steps to be able to get the day of week and the hour a request was created.
When a Request is created a request_event record of ‘OPEN’ is created. A business rule is fired that uses the <perform_exec_db_edit> and I would set user_def1 = datename(dw,event_dttm) and user_def2 = datename(hh,event_dttm).
This would set the Monday, Tuesday etc. in USD1 and the hour in USD2.Because this is updating the record at the Database level a) it won’t trigger anything else and b) be careful.
At the same time I’d send a request to the SME to check the event 2 minutes later. This would then update the sequence on USD3 was then updated and this is the trigger for business rule.
Using your example above.
User_def1 = Monday,Tuesday,Wednesday etc.
User_def2 = 17,18,19,20,21,22,23,00,01,02 etc.
User_def3 = changed to ‘Send Email’
This would then trigger the request event notification to correct team based on the inputs.
I'd imagine there's a more elegant way of doing it, yet to find it though.
Hope this helps
Ady