1st November, DOG. The US President cannot make trade deals on his own, approval lies within the province of the Congress (a Congress with a powerful Irish-American constituency).
As for troops and border duties, the PSNI has stated numerous times that No Deal Brexit presents terrible risks for police officers. Have you now become a Tyrone Jamie Bryson muttering about PSNIRA?
The Senate will back Congress on this...trust me.