Generally it is always easier to get an upgrade on a shorter stay than a longer one. If you show up at 3:00 o'clock at the front desk and ask for an upgrade and they have available rooms, then the chances of them being able to sell those rooms are less than for, say, 5 nights out.