The finale, airing on HBO on August 14, will reveal if Carrie gets a happy ending. The Sex and The City reboot is ending after three seasons, following years of fan backlash