RE: [KCFusion] brain teaser

[Bruce Dunwiddie]

dateformat( now, "dddd" ) will give you the long name of today's date. I can't think of anything better currently other than looping through the next 7 days and trying to find the next monday and then you could go from there using dateadd if need be.   Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adaryl "Bob" Wakefield Sent: Friday, March 05, 2004 5:13 PM To: [EMAIL PROTECTED] Subject: [KCFusion] brain teaser The crayon pusher and I were working on this (actually I was only devoting half my brain to it) he had to run pick up his kid but I was wondering what it took to have the Monday though Friday date spit out dynamically so we would not have to update this schedule every week. look something like 3/8-3/12 3/15-3/19 and so on. We were messing with the now function but could not come up with anything neat and clean.   Adaryl Wakefield Realtor www.bobwakefield.net