I am about to rip my hair out (over something that is probably obvious to everyone else!)
I have set up an email automation to be sent to the team when a finance date has passed. However the email is sending whenever a date is entered into the field (not when its overdue) and in the email automation the date doesn’t match what is entered into the field and states that its a month earlier.
This is the automation I have set up at the moment. The second date field is to ensure that if finance approval has been received already a reminder is not sent.
and this is the email that is sent.
However when the email comes through, it gets as soon as I enter any date in the Finance Due field and then the date in the email doesn’t match the date in the field that it is meant to be pulling from. eg, the correct date for this one should have been the 8th September 2021 not the 8th August 2021.
Any help would be greatly appreciated!