Home > IT Answers > Business Intelligence > Crystal reports formula – equal or less than 60 days
Monk2008
30 pts.
 Crystal reports formula – equal or less than 60 days
Crystal Reports, Crystal Reports formulas, Crystal Reports XI
Hi I am using crystal report XI I am trying to set -up a formula to retrieve all records where the Expiration EndDate <= 60 Days to Current date. Thanks.

Software/Hardware used:
ASKED: July 9, 2009  8:19 PM
UPDATED: July 17, 2009  8:31 PM
RELATED QUESTIONS
Answer Wiki:
Okay, so you place in the selection formula <pre> {TRXPOL.PreAuthEndDate} in currentdate to Currentdate + 60 </pre> This will pull all records with an expirationEndDate between the date you are running the report and 60 days after the date you run it. If you want to pull all records, but list them as you have below, the put your code in an if statement <pre> IF {TRXPOL.PreAuthEndDate} < Currentdate + 60 Then “Pre- Authorization is less than 60 Days” Else “Pre- Authorization Expired” </pre> and place this in the select statement: <pre> {TRXPOL.PreAuthEndDate} < Currentdate + 60 </pre>
Last Wiki Answer Submitted:  July 17, 2009  8:30 pm  by  Jade1977   440 pts.
All Answer Wiki Contributors:  Jade1977   440 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hi Monk2008,

Thank you for clarifying on the program — hopefully one of our members can find you an answer shortly!

Thanks,
Jenny
Community Manager

JennyMack
 4,265 pts.
 

Thanks Jane for your help. Can you give me a bit more detail.
I am a bit of a novice at CR so, bear with me. I am looking to retrieve all records where {TRXPOL.PreAuthEndDate} is <= 60 days. How can I get it to do something like this

IF {TRXPOL.PreAuthEndDate} < Currentdate + 60 Then
“Pre- Authorization is less than 60 Days” Else
“Pre- Authorization Expired”

Not sure if this will help any but, I also have {TRXPOL.PreAuthStartDate}
Thank you.

Monk2008
 30 pts.
 

Okay, so you place in the selection formula

{TRXPOL.PreAuthEndDate} in currentdate to Currentdate + 60

This will pull all records with an expirationEndDate between the date you are running the report and 60 days after the date you run it.

If you want to pull all records, but list them as you have below, the put your code in an if statement

IF {TRXPOL.PreAuthEndDate} < Currentdate + 60 Then
“Pre- Authorization is less than 60 Days” 
Else
“Pre- Authorization Expired”

and place this in the select statement:

 {TRXPOL.PreAuthEndDate} < Currentdate + 60
Jade1977
 440 pts.