First, I would put all of the special dates, with their respective
hours, in a DB table.
Then, depending on your database platform, either create a Calendar
table with dates for many years to come, or, if you have SQL Server, use
the query in the link below:
, for the exceptions table, will be empty. However,
where there is a value, use it instead of the default opening hours
value.
Mike
-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2008 8:26 AM
To: cf-talk
Subject: RE: Slotting dates
: RE: Slotting dates into standard date range
First, I would put all of the special dates, with their respective hours, in
a DB table.
Then, depending on your database platform, either create a Calendar
table with dates for many years to come, or, if you have SQL Server, use the
query in the link
Make sure it's OUTER, so you get all records. :)
Mike
-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2008 8:33 AM
To: cf-talk
Subject: RE: Slotting dates into standard date range
Both sets of data will be stored in a db, standard and non
4 matches
Mail list logo