Ha.. me again... one more
When you do the monthly activity, the last line may show an incorrect date
URL
https://www.delta.com/monthlystmt/servlet/MonthlyStmt
The last line that reads
"Medallion Qualification Miles as of 13 Feb 2009"
should most likely be
"Medallion Qualification Miles as of MM/DD/YYYY" where MM/DD/YYYY is the last day of the statement's month
you can do a dateadd, month, 1 to the beginning of the statement motnh and then subtract one second - takes you at 23:59:59.990 of the last day of the previous (i.e. the current statement's) month, regardless of 30/31/23/29 day length :-D
i love sql