Detail Date Formula Crystal XI

10 pts.
Tags:
Crystal Reports
Crystal Reports Date Calculation
Crystal Reports XI
I have a report as follows, (min date grp) (max date grp) Name ID Elig Eff Dt Elig Trm Dt GRP Smith, John M1234567 02/01/2007 12/31/2078 DET1 Smith, John M1234567 02/01/2007 02/01/2007 DET2 Smith, John M1234567 08/01/2008 12/31/2078 Ok, What I need to be able to do is calculate at the detail level the term date on DET1 from the eff date on DET2, the difference betweeen 02/01/2007 and 08/01/2008, I need to be able to show at the grp level that because this time frame is more than 90 days the eff date should actually be 08/01/2008 NOT 02/01/2007. I need to know the number of days between (DET1 Term Dt) 2/1/2007 and (DET2 Eff Dt) 8/1/2008. Can this be done and if so any/all help would be appreciated.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following