Just to clarify, but recognizing the OP is probably referring to ongoing use:

- CIA will consider you if you smoked marijuana in the past, up until 90 days before applying -- or after applying.

- CIA will consider you if you have used illicit drugs up until a year prior to applying at CIA.

https://www.cia.gov/cia-requirements/