Activated charcoal can last in an aquarium for a few days or weeks, depending on how often the aquarium is cleaned.