How long does a drug charge that my fiance has its his first one wen he got arrested they found drugs and a weed pipe

First offense, marijuana and paraphernalia? This could be settled with a pre-sentence intervention where your fiance pays a fine and goes to class for a few days. There is probably no way to get it "erased", as that is his record now, unless this intervention comes with an expungment too.