paid with 28 after letter printed formula

[javedi]

Hello

I've been attempting to but with no success write a formula to show the records where a record had been paid with 28 days after a letter had been sent out.

The following formula shows notices paid after a letter had been sent but not within 28 days.

@paidletter
if not ({CorrespondenceGroups.Name} in ["Payments", "Payment Returns", "Payment Refunds", "FIX", "Permits"])
and
{CorrespondenceRequestsLog.Status} = 03 // checks the printed status == "successfully printed"
and {Payments.PaymentDate} > {Documents.PrintedDate} then {Notices_1.NoticeNo} else {@null}

I have also made attempts to modify as below, but again to no success.

@paidletter2
if not ({CorrespondenceGroups.Name} in ["Payments", "Payment Returns", "Payment Refunds", "FIX", "Permits"])
and
{CorrespondenceRequestsLog.Status} = 03 // checks the printed status == "successfully printed"
and {Payments.PaymentDate} > {Documents.PrintedDate} in 0 to 28 then {Notices_1.NoticeNo} else {@null}

The error message shows as 'a boolean arrays is required here'

Has anyone got any idea's?

Thanks,
Javedi

 

[CoSpringsGuy]

try just putting this in your record selection formula

//
not ({CorrespondenceGroups.Name} in ["Payments", "Payment Returns", "Payment Refunds", "FIX", "Permits"])
and
{CorrespondenceRequestsLog.Status} = 03
and
{Payments.PaymentDate} >= {Documents.PrintedDate}
and
{Payments.PaymentDate} <= {Documents.PrintedDate} -28


_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[lbass]

I think that should be "+ 28".

-LB

 

[CoSpringsGuy]

whups ... thanks Lbass

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection