Anna8
My husband was diagnosised in 2012 and started "needing to go home" several years ago, mainly in the afternoon when his Sundowners would start. He would get extremely upset and agitated, needing to get out of here (our home for many years) and "go home".
At first, I tried to reason with him that we were home, but of course, that never worked, especially when he was already upset.
So I just tried to make him feel better.
I would tell him we needed to stay here tonight and make a plan in the morning.
Sometimes I would tell him it was too late to leave now, we need to rest here tonight.
Sometimes I'd blame the weather. I heard a big storm is coming, and we need to stay here where we're safe and decide in the morning.

I leave the room for a few minutes, come back with a big smile on my face like everything is fine, and tell him why don't we have a snack, or some tea, or whatever distraction you can think of.
These ideas don't always work and there is alots of repeating the same reasurances, over and over.
I'd like to tell you that it's short lived but in our case it still happens almost daily.