I first mentioned the Lancome Teint Idole Ultra 24H ($44) in my Sephora haul about a month ago and since then I've been using it almost every day. I have the product in the shade 310 Bisque and it was color matched to my skin during the summer, so unfortunately, this probably won't work for me during the colder months. However, I'm extremely happy with the product and it's actually converted me back to foundation from tinted moisturizer.
The product says that it lasts for 24 hours but really, who wears makeup for 24 hours?! Anyways, it definitely lasts all day because I have normal to combination skin and I apply it at around 7:30 in the morning of my longest school day and get home at 9:30 at night and I still have an almost flawless look to my skin.