i have a NOW statement in a workflow that for the life of me cannot figure out how to make it work .
current trigger
account > last send date > date > NOW > -5 hours
so reading on the NOW statement it should trigger 5 hours before the date/time on the date/time field selected . but it doesnt
date/time field set in example to 7/08/2019 10:00 am so it should trigger at 5 am . verified that the date/time is set to this time
i can get this to work by changing the NOW statement to just DATE/TODAY and then it fires when ever it feels like .
any pointers .
want a trigger to fire at a specific time for client workflow email .
example . want a trigger to fire at 5am on the date X.X.X
ideally want this to only send out on monday - friday .
also sencod questioin i cannot figure out much on the BUSINESS statement . i get what that means but where do i set those hours/days . cannot locate the project tab that function talks about