We're waiting for a change in the posture against cannabis at the Federal level [1], but it has been possible to get a security clearance even if you have used marijuana. Looking at the public guidelines [2] there's a distinction between "ever" and "in the last 90 days".