Visual Basic Crystal Reports - need help with date formula

Author

need help with date formula - pronto!

andrea.dominguez

2005-05-27, 8:59 pm

Hello,

I am writing a formula for a group that goes something like this:

if {contact2.UDATE1} in currentdate -90 to currentdate and isnull
({contact2.UYIKES}) then totext ("Group1") else
if {contact2.UDATE2} in currentdate -90 to currentdate and isnull
({contact2.UYOW}) then totext ("Group1") else totext ("Other")

These are date fields and I am using CR9 w/ Goldmine 6.7 MS SQL 2000.

My problem is that the first part of the formula (group1) works great but it
is not looking past group when the report runs.

why is that???

andrea.dominguez

2005-05-27, 8:59 pm

I made a typo- i'm sorry

this is what it should be:

> if {contact2.UDATE1} in currentdate -90 to currentdate and isnull
> ({contact2.UYIKES}) then totext ("Group1") else
> if {contact2.UDATE2} in currentdate -90 to currentdate and isnull
> ({contact2.UYOW}) then totext ("Group2") else totext ("Other")

"andrea.dominguez" <andrea.dominguez@comcast.net> wrote in message
news:#DQNGAvYFHA.2684@TK2MSFTNGP09.phx.gbl...
> Hello,
>
> I am writing a formula for a group that goes something like this:
>
> if {contact2.UDATE1} in currentdate -90 to currentdate and isnull
> ({contact2.UYIKES}) then totext ("Group1") else
> if {contact2.UDATE2} in currentdate -90 to currentdate and isnull
> ({contact2.UYOW}) then totext ("Group1") else totext ("Other")
>
> These are date fields and I am using CR9 w/ Goldmine 6.7 MS SQL 2000.
>
> My problem is that the first part of the formula (group1) works great but
it
> is not looking past group when the report runs.
>
> why is that???
>
>
>
>
>

Sponsored Links