in the Exchange business we have the concept of a Trading Calendar. All trading days are listed in this table going 10 years into the future with a coresponding incrementing integer denoting the day.

DayNumTradingDateCreatedModifiedDeletedFlag

.

.

71342009-01-28 00:00:00.0002006-07-15 05:11:17.2002009-02-04 01:01:37.6430

71352009-01-29 00:00:00.0002006-07-15 05:11:17.2002009-02-04 01:01:37.6430

71362009-01-30 00:00:00.0002006-07-15 05:11:17.2132009-02-04 01:01:37.6430

71372009-02-02 00:00:00.0002006-07-15 05:11:17.2132009-02-04 01:01:37.6430

71382009-02-03 00:00:00.0002006-07-15 05:11:17.2132009-02-04 01:01:37.6430

71392009-02-04 00:00:00.0002006-07-15 05:11:17.2132009-02-04 01:01:37.6430

.

.

.

Alan Cranfield