If you brush your teeth at least twice a day and use teeth whitening products you should see whiter teeth within 2 weeks.
Whitening toothpaste itself won't do much whitening on it's own if the teeth are really discolored but it will help to remove surface stains from your teeth.