Solved

Calculating Dates in Crystal

Posted on 2007-12-06
3
466 Views
Last Modified: 2011-04-14
Can anyone tell me how to set up a formula field that calculates a specific date (i.e. 5 business days) from a month end date (specified from a parameter the user enters).  For example, the user choses the month end of December 31, 2007 for the parameter, then this formula field would calculate X number of business from that date (based on another field from a query) resulting in that date. Thanks!
0
Comment
Question by:colleenasmith
  • 2
3 Comments
 
LVL 17

Accepted Solution

by:
MIKE earned 125 total points
ID: 20423727
See www.kenhamady.com he has formula section there...that deals with this issue..

MikeV
0
 

Author Comment

by:colleenasmith
ID: 20424164
That works great!  Thanks!
0
 
LVL 17

Expert Comment

by:MIKE
ID: 20424172
Glad I could be of service...
MikeV
0

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Crystal Reports - Display Last Invoice in Group 15 69
Crystal Reports Date Formula Failure 26 116
Crystal Reports with Yardi error 800a004b 2 120
Crystal Reports 2013 25 35
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question