The sands would be open est abt Q2 of 2010 with most of the shopping and casino. By the way, when the casino opens it might be very hard to get rooms as there may be a large amount of waitlisted people from around the world who want to stay and gamble at the resort.
No date for the official or soft opening has been released thus far.