It's the pilot's responsibility to have read "up to date" briefing information before departure, so just before is best.
If I'm planning a journey I check NOTAMs a couple of days before; there are a few locations near my home field that regularly put on competitions, displays etc. and if I know in advance I can plan a route that avoids.
But then I check again on the day, to pick up anything new.
RC