Fruit pizza can last at least 12 hours without becoming soggy. After that, the fruit can start to break down, release juices, and make the sugar cookie crust soggy. I recommend serving immediately for the best flavor and texture.