What is to be expected at the end of two year contract?

You must be a non-customer for 6 months to get any 'new customer' promotions.

Call the CS number and ask for Retentions.  Explain that your contract is about to expire and while you'd like to keep the service, you just can't afford it.  Hopefully, they can offer some sort of discount.

Do I need to cancel for a day and then become a "new customer" again.

I still appears stupid in writing as it sounds when said out loud.

It's just as stupid to the cable companies too.  They long since anticipated such moves and I believe there is no cable company that would allow that.  But if you can change your billing address...

As mentioned retentions is the proper department to call to see what promotions are available to you.  But never expect to get what a new customer gets.  You need to be prepared to live with what they offer, downgrade to something acceptable, or cancel.  As to what they can offer, that changes often (so they say) so they may not be prepared to quote you offers until the last billing date of your current promotion or pretty close to it.

@skeeterintexas 

The 6-month wait time for att is the first time I've heard an actual number.  I knew there was a wait time but I could never find out  exactly how much it was.

There was a discussion awhile back about what constituted a "new customer".  In my feeble mind, 6 months was the number that was settled on.  It might have even been a year. 

Those door-to-door sales people are contractors, NOT AT&T employees and they will say whatever it takes to sign up a new customer.  I doubt that they have a clue as to what company policy is.