Hey Jamie, For good UDF's on dates, you may like to visit www.cflib.org.
There are heaps of date based functions in there. Warm Regards, Sameer S. Kekade. QUATRO FOUR RETAIL "The right connections for your business" Tel. direct +61 2 9370 2775 Tel. direct +61 2 9370 1062 Fax direct +61 2 9370 1200 Mobile 0409 156 038, 0411 566 650 [EMAIL PROTECTED] www.quatro.com.au -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamie Lawrence Jenner Sent: Thursday, 14 April 2005 8:16 AM To: CFAussie Mailing List Subject: [cfaussie] Re: advert scheduler Hi Scott, the database has already been designed, this is not the problem, the problem i have is outputting the start date and end date of week 1, week 2, week 3 etc It would be nice to have a startdate(week4) and an endDate(week4) function thanks very much for your response though jam > Hi, > > > Create a table that holds date information that has: > an ID field, > Day, > Week, > Year, > Financial Year, > And any other field that would make reporting/displaying easier. > > A table that would hold "slot" information (in case you require more > slots. less slots etc). So for each day, you would have a number of > slots > > And a slot "usage" table...... a table that joins slots to > advetisements (or you could do this in the above table I suppose). > > > > Easy. > > >>> [EMAIL PROTECTED] 14/04/2005 2:40:23 am >>> > Hi folks, > > Heres the dilemma. > > My client requires that i create an area on their site where they can > place ads on ttheir site. > > There is a limit of four ads per page. The ad slots are in slots of > one week, monday to friday, 52 weeks a year. What i need is to show > the following info > > week 3 - slot 1 - 3rd March > 10th March >>>>>> No ads > week 3 - slot 2 - 3rd March > 10th March >>>>>> Jims Kitchens week 3 - > slot 3 - 3rd March > 10th March >>>>>> Barneys buses week 3 - slot 4 - > 3rd March > 10th March >>>>>> No ads > > week 4 - slot 1 - 11th March > 17th March >>>>>> Dereks drills week 4 > - slot 2 - 11th March > 17th March >>>>>> Jims Kitchens week 4 - slot > 3 - 11th March > 17th March >>>>>> Barneys buses week 4 - slot 4 - > 11th March > 17th March >>>>>> No ads > > Then m client can print out reports detailing what ads are ona dn > when, and what slots are free. The trouble i am having, is showing the > start date and end date for a particular week. Does anyone have any > ideas on how > i can do this? > > my initial thoughts is maybe having all months and dates assigned to > days of the week in the db, > > monday - 11th March, 18th march, 25th march > tuesday - 12th march, 19th march, 26th March > wednesday and so on > > Then once every year, re assign the dates to the days. > > Any one got a ny better solutions? > > cia > > jamie > > > > > --- > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
