Hi LB,
Thanks for the formula. There is only one problem and I may not have stated this clearly in my original post {table.date} will always be <= currentdate. So what I need are only the outputs that are >= currentdate if that makes sense. So For example:
If {table.date} is 12/4/2007 and...
Hello,
Here is my setup Crystal Reports 9 running against SQL Server Database. Based on the field {OPENCLOSE.GENERICDATE1} I need to display a target date every 6 months for at least the next 5 years.
I am able to do one 6 month interval with the following formula
DateAdd ("m", 6...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.