RE: Data-modeling for anniversaries...

[Jay Sudowski - Handy Networks LLC]

Hi David,

You might want to check into the DatePart function - (the Access
DatePart function, not the CF DataPart function.  They both work the
same way, but have slightly different syntax).

<cfquery name="weeklyAni" datasource="whatever">
Select name, anidate from ani where AniDate = DatePart("ww", now())
</cfquery>

HTH.

Jay Sudowski
---------------------
Handy Networks LLC
TEL: 877-70-HANDY
FAX: 888-300-2FAX
URL: www.handynetworks.com <http://www.handynetworks.com> 
---------------------
Providing reseller and dedicated Windows 2000 web hosting solutions.


-----Original Message-----
From: David Grabbe [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, July 31, 2001 3:17 PM
To: CF-Talk
Subject: RE: Data-modeling for anniversaries...



        Is there a way to do the same thing in Access2000?

David



-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 3:09 PM
To: CF-Talk
Subject: RE: Data-modeling for anniversaries...


I would use a series of database functions to turn the original date
into a date in the current year, like this (Oracle-ish code since I
don't know what DB you're using but am too lazy to find the exact
syntax):

to_date (to_char(aniv_date_field, 'm-d') + '-' + currentyear(),
'm-d-yyyy' )

now I have a "date field" and can compare to today and today + 7 days.

-----Original Message-----
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 1:31 PM
To: CF-Talk
Subject: Data-modeling for anniversaries...



I've run into a data-modeling stumper.  I have a database table which
contains wedding anniversaries and the respective couple's name.  The
date is stored as the wedding date, so calculating the anniversary is
easy.  The primary usage of this is to display the anniversaries on a
monthly calendar. However, now i need to select just the anniversaries
which will be coming up in the next week.  The problem is that since the
dates are stored with the original years (i.e. 11/28/1970), I can't just
select the dates that are between a specific date range, because the
year will throw that all out of whack.  So how can i select based just
on the month/day, also taking into account that in the middle of the
"week" the month can change to the next month (November-December)?  Any
ideas?


Cheers,
David
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists