Crystal Functions

Cool beans your welcome.

Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ace_Man
Sent: Monday, April 03, 2006 5:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Functions


Once again, Frank, Thank You! ... That worked great.

--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@...>
wrote:
>
> Try this then,
>
> ((month(orderhead.orderdate) = month(today())) and
> (year(orderhead.orderdate) = year(today())))
> or if month(orderhead.orderdate) = 12
> then
> ((month(orderhead.orderdate) = month(today() + 1))
and
> (year(orderhead.orderdate) = year(today() + 1)))
> else
> ((month(orderhead.orderdate) = month(today() + 1))
and
> (year(orderhead.orderdate) = year(today())))
>
> I am sure this is more elgant ways but I am hoping this will get
the job
> done. I think I nailed it this time.
>
> Let me know how you make out.
>
>
> Innovative Office Products, Inc.
> Frank Zeigafuse
> General Manager
> 610-559-6369
> fzeigafuse@...
>







Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Crystal has a MonthToDate function that returns dates from the
beginning of the month to what ever date you fall into. But what
function is used when you are in any date between the calendar month
and you want from the day you are in to the end of the month?

Thanks in advance
What are you using it for? If I understand our intent I might be able
to help propose another solution.

Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ace_Man
Sent: Monday, April 03, 2006 11:57 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Functions


Crystal has a MonthToDate function that returns dates from the
beginning of the month to what ever date you fall into. But what
function is used when you are in any date between the calendar month
and you want from the day you are in to the end of the month?

Thanks in advance





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
I'm trying to create a report that will tell me the orders(backlog)
made from whatever day I run the report to the rest of the month,
then for the next month, then the rest of the dates after that.


--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@...>
wrote:
>
> What are you using it for? If I understand our intent I might be
able
> to help propose another solution.
>
> Innovative Office Products, Inc.
> Frank Zeigafuse
> General Manager
> 610-559-6369
> fzeigafuse@...
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Ace_Man
> Sent: Monday, April 03, 2006 11:57 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Functions
>
>
> Crystal has a MonthToDate function that returns dates from the
> beginning of the month to what ever date you fall into. But what
> function is used when you are in any date between the calendar
month
> and you want from the day you are in to the end of the month?
>
> Thanks in advance
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
Ok, why not just use (month(orderhead.orderdate) = month(today())) or
(month(orderhead.orderdate)) = month(today() + 1))

Basically you are only concerned about the month, not the date. My only
concern would like year end.

Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ace_Man
Sent: Monday, April 03, 2006 12:21 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Functions


I'm trying to create a report that will tell me the orders(backlog)
made from whatever day I run the report to the rest of the month,
then for the next month, then the rest of the dates after that.


--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@...>
wrote:
>
> What are you using it for? If I understand our intent I might be
able
> to help propose another solution.
>
> Innovative Office Products, Inc.
> Frank Zeigafuse
> General Manager
> 610-559-6369
> fzeigafuse@...
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Ace_Man
> Sent: Monday, April 03, 2006 11:57 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Functions
>
>
> Crystal has a MonthToDate function that returns dates from the
> beginning of the month to what ever date you fall into. But what
> function is used when you are in any date between the calendar
month
> and you want from the day you are in to the end of the month?
>
> Thanks in advance
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>






Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Thanks Frank, that's exactly what I was looking for.

--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@...>
wrote:
>
> Ok, why not just use (month(orderhead.orderdate) = month(today()))
or
> (month(orderhead.orderdate)) = month(today() + 1))
>
> Basically you are only concerned about the month, not the date.
My only
> concern would like year end.
>
> Innovative Office Products, Inc.
> Frank Zeigafuse
> General Manager
> 610-559-6369
> fzeigafuse@...
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Ace_Man
> Sent: Monday, April 03, 2006 12:21 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Functions
>
>
> I'm trying to create a report that will tell me the orders
(backlog)
> made from whatever day I run the report to the rest of the month,
> then for the next month, then the rest of the dates after that.
>
>
> --- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@>
> wrote:
> >
> > What are you using it for? If I understand our intent I might be
> able
> > to help propose another solution.
> >
> > Innovative Office Products, Inc.
> > Frank Zeigafuse
> > General Manager
> > 610-559-6369
> > fzeigafuse@
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of Ace_Man
> > Sent: Monday, April 03, 2006 11:57 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Crystal Functions
> >
> >
> > Crystal has a MonthToDate function that returns dates from the
> > beginning of the month to what ever date you fall into. But what
> > function is used when you are in any date between the calendar
> month
> > and you want from the day you are in to the end of the month?
> >
> > Thanks in advance
> >
> >
> >
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must
> > have already linked your email address to a yahoo id to enable
> access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
> Builder
> > and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/links
> > Yahoo! Groups Links
> >
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
I hope it works !! :)

Let me know.

Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ace_Man
Sent: Monday, April 03, 2006 2:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Functions


Thanks Frank, that's exactly what I was looking for.

--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@...>
wrote:
>
> Ok, why not just use (month(orderhead.orderdate) = month(today()))
or
> (month(orderhead.orderdate)) = month(today() + 1))
>
> Basically you are only concerned about the month, not the date.
My only
> concern would like year end.
>
> Innovative Office Products, Inc.
> Frank Zeigafuse
> General Manager
> 610-559-6369
> fzeigafuse@...
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Ace_Man
> Sent: Monday, April 03, 2006 12:21 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Functions
>
>
> I'm trying to create a report that will tell me the orders
(backlog)
> made from whatever day I run the report to the rest of the month,
> then for the next month, then the rest of the dates after that.
>
>
> --- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@>
> wrote:
> >
> > What are you using it for? If I understand our intent I might be
> able
> > to help propose another solution.
> >
> > Innovative Office Products, Inc.
> > Frank Zeigafuse
> > General Manager
> > 610-559-6369
> > fzeigafuse@
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of Ace_Man
> > Sent: Monday, April 03, 2006 11:57 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Crystal Functions
> >
> >
> > Crystal has a MonthToDate function that returns dates from the
> > beginning of the month to what ever date you fall into. But what
> > function is used when you are in any date between the calendar
> month
> > and you want from the day you are in to the end of the month?
> >
> > Thanks in advance
> >
> >
> >
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must
> > have already linked your email address to a yahoo id to enable
> access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
> Builder
> > and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/links
> > Yahoo! Groups Links
> >
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>






Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Well.. it's also pulling the ones for next year. How do I go around
that?

--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@...>
wrote:
>
> I hope it works !! :)
>
> Let me know.
>
> Innovative Office Products, Inc.
> Frank Zeigafuse
> General Manager
> 610-559-6369
> fzeigafuse@...
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Ace_Man
> Sent: Monday, April 03, 2006 2:03 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Functions
>
>
> Thanks Frank, that's exactly what I was looking for.
>
> --- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@>
> wrote:
> >
> > Ok, why not just use (month(orderhead.orderdate) = month(today
()))
> or
> > (month(orderhead.orderdate)) = month(today() + 1))
> >
> > Basically you are only concerned about the month, not the date.
> My only
> > concern would like year end.
> >
> > Innovative Office Products, Inc.
> > Frank Zeigafuse
> > General Manager
> > 610-559-6369
> > fzeigafuse@
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of Ace_Man
> > Sent: Monday, April 03, 2006 12:21 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Crystal Functions
> >
> >
> > I'm trying to create a report that will tell me the orders
> (backlog)
> > made from whatever day I run the report to the rest of the month,
> > then for the next month, then the rest of the dates after that.
> >
> >
> > --- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@>
> > wrote:
> > >
> > > What are you using it for? If I understand our intent I might
be
> > able
> > > to help propose another solution.
> > >
> > > Innovative Office Products, Inc.
> > > Frank Zeigafuse
> > > General Manager
> > > 610-559-6369
> > > fzeigafuse@
> > >
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On
> > Behalf
> > > Of Ace_Man
> > > Sent: Monday, April 03, 2006 11:57 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Crystal Functions
> > >
> > >
> > > Crystal has a MonthToDate function that returns dates from the
> > > beginning of the month to what ever date you fall into. But
what
> > > function is used when you are in any date between the calendar
> > month
> > > and you want from the day you are in to the end of the month?
> > >
> > > Thanks in advance
> > >
> > >
> > >
> > >
> > >
> > > Useful links for the Yahoo!Groups Vantage Board are: ( Note:
You
> > must
> > > have already linked your email address to a yahoo id to enable
> > access. )
> > > (1) To access the Files Section of our Yahoo!Group for Report
> > Builder
> > > and Crystal Reports and other 'goodies', please goto:
> > > http://groups.yahoo.com/group/vantage/files/.
> > > (2) To search through old msg's goto:
> > > http://groups.yahoo.com/group/vantage/messages
> > > (3) To view links to Vendors that provide Vantage services
goto:
> > > http://groups.yahoo.com/group/vantage/links
> > > Yahoo! Groups Links
> > >
> >
> >
> >
> >
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must
> > have already linked your email address to a yahoo id to enable
> access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
> Builder
> > and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/links
> > Yahoo! Groups Links
> >
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
Try this then,

((month(orderhead.orderdate) = month(today())) and
(year(orderhead.orderdate) = year(today())))
or if month(orderhead.orderdate) = 12
then
((month(orderhead.orderdate) = month(today() + 1)) and
(year(orderhead.orderdate) = year(today() + 1)))
else
((month(orderhead.orderdate) = month(today() + 1)) and
(year(orderhead.orderdate) = year(today())))

I am sure this is more elgant ways but I am hoping this will get the job
done. I think I nailed it this time.

Let me know how you make out.


Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ace_Man
Sent: Monday, April 03, 2006 4:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Functions


Well.. it's also pulling the ones for next year. How do I go around
that?

--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@...>
wrote:
>
> I hope it works !! :)
>
> Let me know.
>
> Innovative Office Products, Inc.
> Frank Zeigafuse
> General Manager
> 610-559-6369
> fzeigafuse@...
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Ace_Man
> Sent: Monday, April 03, 2006 2:03 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Functions
>
>
> Thanks Frank, that's exactly what I was looking for.
>
> --- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@>
> wrote:
> >
> > Ok, why not just use (month(orderhead.orderdate) = month(today
()))
> or
> > (month(orderhead.orderdate)) = month(today() + 1))
> >
> > Basically you are only concerned about the month, not the date.
> My only
> > concern would like year end.
> >
> > Innovative Office Products, Inc.
> > Frank Zeigafuse
> > General Manager
> > 610-559-6369
> > fzeigafuse@
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of Ace_Man
> > Sent: Monday, April 03, 2006 12:21 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Crystal Functions
> >
> >
> > I'm trying to create a report that will tell me the orders
> (backlog)
> > made from whatever day I run the report to the rest of the month,
> > then for the next month, then the rest of the dates after that.
> >
> >
> > --- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@>
> > wrote:
> > >
> > > What are you using it for? If I understand our intent I might
be
> > able
> > > to help propose another solution.
> > >
> > > Innovative Office Products, Inc.
> > > Frank Zeigafuse
> > > General Manager
> > > 610-559-6369
> > > fzeigafuse@
> > >
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On
> > Behalf
> > > Of Ace_Man
> > > Sent: Monday, April 03, 2006 11:57 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Crystal Functions
> > >
> > >
> > > Crystal has a MonthToDate function that returns dates from the
> > > beginning of the month to what ever date you fall into. But
what
> > > function is used when you are in any date between the calendar
> > month
> > > and you want from the day you are in to the end of the month?
> > >
> > > Thanks in advance
> > >
> > >
> > >
> > >
> > >
> > > Useful links for the Yahoo!Groups Vantage Board are: ( Note:
You
> > must
> > > have already linked your email address to a yahoo id to enable
> > access. )
> > > (1) To access the Files Section of our Yahoo!Group for Report
> > Builder
> > > and Crystal Reports and other 'goodies', please goto:
> > > http://groups.yahoo.com/group/vantage/files/.
> > > (2) To search through old msg's goto:
> > > http://groups.yahoo.com/group/vantage/messages
> > > (3) To view links to Vendors that provide Vantage services
goto:
> > > http://groups.yahoo.com/group/vantage/links
> > > Yahoo! Groups Links
> > >
> >
> >
> >
> >
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must
> > have already linked your email address to a yahoo id to enable
> access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
> Builder
> > and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/links
> > Yahoo! Groups Links
> >
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>






Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Once again, Frank, Thank You! ... That worked great.

--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@...>
wrote:
>
> Try this then,
>
> ((month(orderhead.orderdate) = month(today())) and
> (year(orderhead.orderdate) = year(today())))
> or if month(orderhead.orderdate) = 12
> then
> ((month(orderhead.orderdate) = month(today() + 1))
and
> (year(orderhead.orderdate) = year(today() + 1)))
> else
> ((month(orderhead.orderdate) = month(today() + 1))
and
> (year(orderhead.orderdate) = year(today())))
>
> I am sure this is more elgant ways but I am hoping this will get
the job
> done. I think I nailed it this time.
>
> Let me know how you make out.
>
>
> Innovative Office Products, Inc.
> Frank Zeigafuse
> General Manager
> 610-559-6369
> fzeigafuse@...
>