Print Page | Close Window

Formula for Today's Date Plus 6 Months

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8308
Printed Date: 05 May 2024 at 7:20pm


Topic: Formula for Today's Date Plus 6 Months
Posted By: RogDodge
Subject: Formula for Today's Date Plus 6 Months
Date Posted: 11 Nov 2009 at 2:58pm

Hello all, 

 

I work for a medical institution that uses Crystal for some of our reporting needs.  After we purchased Crystal Reports 2008 so we could build our own reports and not have to outsource them, I ran into a quick question that I cannot seem to get past.

 

We currently have to do Re-Determinations for our clients every 6 months from their last Re-De date.

 

If I create a formula like:

 

{vwProgram_Enrollment_DRS.ILDRSDateLastRedet} + 180

 

It will not take into account for months that have more or less, that 30 days and the Re-de date will be off.

 

Thanks in advance and sorry if this is an amateurish question, I got thrown on making Crystal Reports because I volunteered to go to a seminar about Crystal Reports basics and while I can make simple reports sometimes I just don’t have the “Coding” skills to make more advanced reports..




Replies:
Posted By: DBlank
Date Posted: 11 Nov 2009 at 6:42pm
DateAdd('m',6,CurrentDate)


Posted By: RogDodge
Date Posted: 12 Nov 2009 at 6:46am
Thank you very much, worked perfectly.



Print Page | Close Window