calculate the cut-off dates thus:
Now()
DateAdd('m',-3,Now())
DateAdd('m',-6,Now()))
etc.,
----- Original Message -----
From: "Shally" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, April 27, 2001 9:30 AM
Subject: RE: Report
> Thanks for your reply.
> I am unable to find any proper logic for my problem.
> And well thats the problem:).
> I am tried using "Quarter" function but it only gives
> the the quarter number such as April is in 2nd
> quarter.
> Please help.
> Shally.
> --- Chris Maloney <[EMAIL PROTECTED]> wrote:
> > Considering you didn't paste any errors that you
> > have received with this the
> > first thing I suggest you do is change the name of
> > your date field from
> > 'Date' to something else like 'myDate'. 'Date' is a
> > reserved word in SQL and
> > frequently causes problems because Access will not
> > warn you of this when you
> > are creating a table.
> >
> > Chris
> >
> > -----Original Message-----
> > From: Shally [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, April 26, 2001 10:05 AM
> > To: CF-Talk
> > Subject: Report
> >
> >
> > Hi Every one,
> > I have an access table having 3 fields Date,
> > Quantity
> > and Amount.
> > I am working on a report where I have to calculate
> > the
> > Quantity and Amount on quarterly bases for last year
> > and this year.
> > I tried using the function "Quarter" but an unable
> > to
> > reach any solution.Please help!!
> >
> > Thanks in advance
> > Shally.
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
