# Crystal Functions

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,
>
> 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
>
> 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
(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:
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?

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?

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
(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:
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?
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
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:
>
Ok, why not just use (month(orderhead.orderdate) = month(today())) or

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?
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
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:
>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
(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:
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?
> >
> >
> >
> >
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must
> 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:
> >
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
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:
>
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?
> >
> >
> >
> >
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must
> 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:
> >
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
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:
>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
(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:
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
> > 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:
> > > Yahoo! Groups Links
> > >
> >
> >
> >
> >
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must
> 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:
> >
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
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:
>
Try this then,

then
((month(orderhead.orderdate) = month(today() + 1)) and
else
((month(orderhead.orderdate) = month(today() + 1)) and

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
> > 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:
> > > Yahoo! Groups Links
> > >
> >
> >
> >
> >
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must
> 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:
> >
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
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:
>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
(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:
Once again, Frank, Thank You! ... That worked great.

--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@...>
wrote:
>
> Try this then,
>
> 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
>
> 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@...
>