As Carl noted, sand lasts indefinitely (some dealers with bags of sand to sell, notwithstanding). But, when there's sand in the pool, that can often indicate problems with your filter, your multiport valve, or -- if you replaced your pump -- with a pump that's too large for the filter.

Ben