Midler released a new Christmas album titled Cool Yule in 2006, which featured a duet of Christmastime pop standards "Winter Wonderland"/"Let It Snow" with Johnny Mathis. Well-received, the album garnered a Grammy Award nomination for Best Traditional Pop Vocal Album in 2007. The same year, Midler returned to the big screen, appearing in Then She Found Me, Helen Hunt's feature film directorial debut. Also starring Hunt along with Matthew Broderick and Colin Firth, the comedy-drama film tells the story of a 39-year-old Brooklyn elementary school teacher, who after years is contacted by the flamboyant host of a local talk show, played by Midler, who introduces herself as her biological mother. Critical response to the film was mixed; whereas some critics praised the film for having strong performances, others felt the film was bogged down by a weak script and technical issues.  Midler debuted her Vegas show titled Bette Midler: The Showgirl Must Go On at The Colosseum at Caesars Palace on February 20, 2008. It comprised The Staggering Harlettes, 20 female dancers called The Caesar Salad Girls and a 13-piece band. The show played its final performance on January 31, 2010, and was nominated for a Primetime Emmy Award for Outstanding Variety, Music, or Comedy Special in 2011. Also in 2008, another compilation album by Midler, Jackpot: The Best Bette, was released. It reached number 66 on the U.S. Billboard 200 chart, and number six in the United Kingdom, where it was certified platinum for sales of over 300,000 copies. As her only film appearance that year, Midler had a small role in Diane English's comedy film The Women, starring Meg Ryan, Annette Bening and Eva Mendes among others. An updated version of the George Cukor-directed 1939 film of the same name based on a 1936 play by Clare Boothe Luce, the film was widely panned by critics, who found it "...a toothless remake of the 1939 classic, lacking the charm, wit and compelling protagonists of the original."  Midler appeared on the Bravo TV show My Life on the D-List with Kathy Griffin in an episode that aired in June 2009. In December of the same year, she appeared in the Royal Variety Performance, an annual British charity event attended by Queen Elizabeth II. Midler performed "In My Life" and "Wind Beneath My Wings" as the closing act. In 2010, Midler voiced the character Kitty Galore in the animated film Cats & Dogs: The Revenge of Kitty Galore. The film was a success, grossing $112 million worldwide. In November 2010, Midler released Memories of You, another compilation of lesser known tracks from her catalog. Midler was one of the producers of the Broadway production of the musical Priscilla, Queen of the Desert, which opened in February 2011.

Answer this question "how long did the show run for?" by extracting the answer from the text above.
The show played its final performance on January 31, 2010,