I don't know about time-limited bans, but the way cigarettes have been handled seems to have been pretty effective. Don't ban but instead discourage use in a variety of ways, prohibit advertising, replace with anti-smoking propaganda campaigns, gradually limit permitted public consumption as usage comes down (which it has).

I could see alcohol getting the same sort of treatment in theory, it also has well documented harms to justify doing so. One thing I'd like to see is more social spaces/events for adults that don't implicitly revolve around alcohol consumption. You can't really prevent people who want to drink from doing it, but you could make it less convenient and more convenient for people who don't drink. For instance maybe establishments that serve alcohol shouldn't be allowed to have dedicated parking, since the expectation that someone is going to drive somewhere, drink little enough that they're still entirely good to drive, and then have to either drive back home or face a huge hassle, sets people up for bad decisions.