When a backlink impacts a website's ranking?

There is no time limit. It depends on the quality of the backlinks. If the quality of the links were good, usually we can see the rankings within 2 to 4 weeks. Sometimes it depends on your keyword competition as well.