C#: DateTime.ToString()

Looking for simple, direct examples of what the various DateTime conversion functions do which MSDN was completely incapable of providing. Found a great tutorial article that summarized them nicely:

result = theDate.ToString("y");       // result = "January 2007"

Specifier	Description	Example
d	Short date format. This is equivalent to using ToShortDateString.	"03/01/2007"
D	Long date format. This is equivalent to using ToLongDateString.	"03 January 2007"
f	Date and time using long date and short time format.	"03 January 2007 21:25"
F	Date and time using long date and time format.	"03 January 2007 21:25:30"
g	Date and time using short date and time format.	"03/01/2007 21:25"
G	Date and time using short date and long time format.	"03/01/2007 21:25:30"
m	Day and month only.	"03 January"
r	Date and time in standard Greenwich Mean Time (GMT) format.	"Wed, 03 Jan 2007 21:25:30 GMT"
s	Sortable date and time format. The date elements start at the highest magnitude (year) and reduce along the string to the smallest magnitude (seconds).	"2007-01-03T21:25:30"
t	Short time format. This is equivalent to using ToShortTimeString.	"21:25"
T	Long time format. This is equivalent to using ToLongTimeString.	"21:25:30"
u	Short format, sortable co-ordinated universal time.	"2007-01-03 21:25:30Z"
U	Long format date and time.	"03 January 2007 17:25:30"
y	Month and year only.	"January 2007"

MSACCESS: Searching for Wildcards

Still end up using Microsoft Access alot when manipulating data. Since it uses the old Microsoft wildcard characters, I often forget how to search for the wildcards themselves. Found a good article that summarizes how to do just that:

Search string	Match list setting	Results
[*]	Any Part of Field	Returns all records that contain an asterisk (*). This syntax also works for question marks (?), number signs (#), opening brackets ([), and hyphens (-).
	Whole Field	Returns records that consist only of an asterisk.
	Start of Field	Returns records that start with an asterisk.
*[*]*	Any Part of Field	Returns all records that contain an asterisk (*) and any surrounding text. This syntax also works for question marks (?), number signs (#), opening brackets ([), and hyphens (-).
	Whole Field	Same result.
	Start of Field	Same result.
[!*]	Any Part of Field	Returns all records that do not contain an asterisk. Keep in mind that this search pattern can return every letter of every word in a record when you use this setting in the Match list. This syntax also works for question marks (?), number signs (#), opening brackets ([), and hyphens (-). Note  The search string *[!*]* will return records that contain asterisks because it finds all the text that surrounds the asterisk.
	Whole Field	Returns no results at all.
	Start of Field	Returns the first letter of any record that does not contain an asterisk.
ma*[ch]	Any Part of Field	Returns all records that contain "ma" and either "c" or "h". For example, this string returns "march" and "match", and it also returns "math" and "manic".
	Whole Field	Returns all records that start with "ma" and end with either "c" or "h". For example, this string returns "march" and "match", and it also returns "math" and "manic".
	Start of Field	Returns all records that start with "ma" and contain "c" or "h".
ma*[!ch]	Any Part of Field	Highlights the letters "m" and "a" and all text that follows those letters until it encounters a "c" or an "h". The following figures illustrate this. | March | | Match | In other words, even though you're trying to exclude records that contain "c" and "h", you may see those records because Any Part of Field matches the text that precedes the brackets.
	Whole Field	Returns all records that do not contain a "c" or an "h" if those records end in "c" or "h". For example, the find operation does not return "manic" because the word ends with a "c", but it does return "maniacal" because characters follow the "c".
	Start of Field	Returns those records that start with "ma". Again, Access matches any text that precedes the characters enclosed in brackets, so you may see unwanted results.