Formula Help

[mnmdesigns]

I am using CR 10 with SQL Server 2000. My groups are based on the formula which is like this.

if (not isnull({cr_activeemployee.formal_filed})and
(not isnull({cr_activeemployee.issued_accpt_ltr})or
not isnull({cr_activeemployee.issued_part_accpt_ltr}))and
isnull({cr_activeemployee.issued_dismissal_ltr})
then 'Pending Hearing'
else
'Error'

The problem I am having is with the following condition. (not isnull({cr_activeemployee.issued_accpt_ltr})or
not isnull({cr_activeemployee.issued_part_accpt_ltr}))

There are some situations where both of these dates are not null. If so then I would like to show the latest one. Can someone please help me with this?

 

[paulmarr]

As you have yet to receive a response - Try this: (it may work if my assumption of the data types are correct)


if (not isnull({cr_activeemployee.issued_accpt_ltr}) and
not isnull({cr_activeemployee.issued_part_accpt_ltr}))
then if {cr_activeemployee.issued_accpt_ltr}> {cr_activeemployee.issued_part_accpt_ltr}) then
{cr_activeemployee.issued_accpt_ltr}
else
{cr_activeemployee.issued_part_ltr}

else if isnull({cr_activeemployee.issued_dismissal_ltr})
and (not isnull({cr_activeemployee.formal_filed}) and
(not isnull({cr_activeemployee.issued_accpt_ltr}) then
"Pending Hearing"

else if isnull({cr_activeemployee.issued_dismissal_ltr})
and (not isnull({cr_activeemployee.formal_filed}) and
not isnull({cr_activeemployee.issued_part_accpt_ltr}))
then
"Pending Hearing"
else if
"error"


I hope this helps you.
Cheers
paulmarr

 

[mnmdesigns]

Thanks Paul I will give this a try and share my resutls with you.