wouldn't that be dateadd('d', -365, now()) ?
-----Original Message-----
From: Tony Schreiber [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 10:59 AM
To: CF-Talk
Subject: RE: How to compute this DAY (not Date) last year?
> > For a sales report, I need to figure out what the date is for
> > this DAY last year. So for today, 8/5/2003 Tuesday, I need to
> > figure out what the date was for this Tuesday last year
> > (which was 8/6/2002).
> >
> > It's not as simple as today-364 days right? You've got leap
> > years of course and probably some other wrenches in there as
> > well. It's actually probably simple, but my brain is fried
> > right now. ;)
>
> Use DateAdd() to take a year off, then DateFormat() or
> DayofWeekAsString(DayOfWeek()) to get the Day name
No, I don't want the day of this DATE last year. I want the date of this
DAY last year. ;)
Tony Schreiber, Senior Partner Man and Machine, Limited
mailto:[EMAIL PROTECTED] http://www.technocraft.com
http://www.is300.net The Enthusiast's Home of the Lexus IS300 since 1999
***** PARTS STORE NOW OPEN ***** http://www.is300.net/store/
http://www.simplemessageboard.com Free Forum Software for Cold Fusion
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
