> > 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).
>
> What is the definition of "this day last year"? Is that "this day
> of the week d
> 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 pro
So, you want the date of this day last year in the same week as this week? Right?
> -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?
&g
Yes. I think so. ;l
> So, you want the date of this day last year in the same week as this
> week? Right?
>
> > -Original Message-
> > From: Tony Schreiber [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, August 05, 2003 10:59 AM
> > To: CF-Talk
> > Su
ent: 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
Tony Schreiber wrote:
> 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).
What is the definition of "this day last year"? Is that "this day
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
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 ot
> > > > > > 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 tod
-- Original Message --
From: "Bill Henderson" <[EMAIL PROTECTED]>
>If it helps, you add an extra day (02/29) every 4 years except IF the year
>ends in 00 and is divisible by 400.
Actually, if it's divisible by 400 then there is a Feb. 29(there was a Feb. 29
> > 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
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
> > > &
Use the DateAdd() function to subtract from the year DatePart
dateAdd('y',-1,DateObject)
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 11:09 AM
To: CF-Talk
Subject: Re: How to compute this DAY (not Date) last ye
cott Brady [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 2:08 PM
To: CF-Talk
Subject: RE: How to compute this DAY (not Date) last year?
-- Original Message --
From: "Bill Henderson" <[EMAIL PROTECTED]>
>If it helps, you add an extra
son
[EMAIL PROTECTED]
-Original Message-
From: Jim Campbell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 9:21 AM
To: CF-Talk
Subject: Re: How to compute this DAY (not Date) last year?
Don't forget about leap years - that'll be off by a day if you go back
over one.
- Ji
-- Original Message --
From: Tony Schreiber <[EMAIL PROTECTED]>
>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
> Use DateAdd() to take a year off, then DateFormat() or
> DayofWeekAsString(DayOfWeek()) to get the Day name
Oops, didn't read your message properly
Take off the DayOfWeek() from the current date
Take a year off using DateAdd()
Take off any DayOfWeek() from that date
Add the DayOfWeek back on
! Did I miss something?
> > > -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?
> > &g
Tony Schreiber wrote:
>>>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).
>>
>>What is the definition of "this day last year"? Is that "thi
19 matches
Mail list logo