"Of course I do. It's 2278."
In that year, the Bozeman encountered a temporal distortion and was transported forward in time to the year 2368. There, in an area of space known as the Typhon Expanse, it encountered the USS Enterprise-D, with which it collided, causing the Enterprise to explode. The explosion, being in such close proximity to the temporal distortion, ruptured the spacetime continuum, trapping both vessels in a temporal causality loop, wherein the Bozeman continually encountered the Enterprise, and the latter ship was destroyed. Eventually, the crew of the Enterprise was able to realize what was happening and avoid the collision, freeing both vessels from the loop. Bateson subsequently contacted the Enterprise, whereupon he was informed by that ship's captain, Jean-Luc Picard, that Bateson and his crew were stranded in the 24th century. (TNG: "Cause and Effect")
Bateson was the lead character of the Star Trek novel Ship of the Line, the story of which tells of the incident that trapped the Bozeman in the temporal causality loop and the problems of Bateson and the Bozeman crew trying to adjust to life in the 24th century;
In addition to this appearance, Bateson also appeared in short stories in both Strange New Worlds VI and Strange New Worlds VII, the novel Spectre, and an appearance with Montgomery Scott in "Out of Time" in the DC Comics TNG Special 2.
He briefly appears in The Captain's Daughter by Peter David, when Hikaru Sulu has to turn down an appointment as the Bozeman's first officer after discovering the existence of his daughter, Demora. This saves Sulu from being trapped with the rest of the Bozeman's crew.