Today is my 10 year anniversary for joining FreeLotto. I don't think I have visited the site once in the past 9 years:

Dear Sir,
You are receiving this message because you joined FreeLotto on 2000-12-20 16:28:24, from IP Address 204.245.80.70. When you registered you agreed to receive messages from FreeLotto. FreeLotto NEVER sends JUNK or SPAM messages. We never send mail to anyone unless they requested it when they registered. If you somehow didn't understand that you were agreeing to receive messages from us at the time you joined PLEASE CLICK HERE TO BE PERMANENTLY REMOVED FROM OUR LIST. In doing so you will also cancel your FreeLotto membership and you will no longer be eligible to play FreeLotto or receive up to $11,000,000.00 in daily prizes. We regret any inconvenience.
Thank you,
FreeLotto Member Services

I wonder if they will even let me know that it has been ten years. Maybe I should unsubscribe now?

Here are some simple mssql queries if you need to change the current date in a query. That is if you need to find information in the past and don't want to hard code in values.

Using Webaii, Use this code snip to validate the URL of the current page:

// Validate URL
StringAssert.Contains(ActiveBrowser.Url, "dev");

// URL Does Not Contain
Assert.IsFalse(ActiveBrowser.Url.Contains("index.jsp"));

Using WebAii and this code snip to search the HTML source of a page for some data:

// Check for value of a InnerMarkup
string TextString = ActiveBrowser.Find.ByAttributes("id=content").InnerMarkup.ToString();
StringAssert.Contains(TextString, "Company Name");

Using Webaii, here's how to validate that an image is loading correctly on a page:

// Validate Image on Page
Assert.IsNotNull(Find.ByAttributes<HtmlImage>("src=~logo.gif"), "Logo Image is not on the page");

Very useful to have as a code snip.