Common Formula Examples

The following link has formulas that show how to do many commonly requested tasks:

http://www.kenhamady.com/formula.html

The current formulas include:

1. The number of "Work Days" between any two dates:
2. Converting a Numeric Date to True Date:
3. Converting a Character Date to True Date:
4. Use a parameter prompt to select the Sort/Group order, using fields of mixed data types:
5. Adding a month or months to a date:
6. Calculating an accurate Age Integer from a Date of Birth:
7. Printing Parameter Selections for Multiple or Range Values:
8. Making Multiple Variable Assignments in One Formula:
9. Converting total seconds to a formatted "elapsed time" string:
10. Conditional Total using an If-Then-Else formula:
11. Conditional Total using a Running Total:
12. Manual Cross-Tabs (Cross-Tabs that allow formulas):
13. The number of Business Hours between DateTime Values.
14. Distinct Count of an If-Then-Else Formula.
15. Convert Decimal Numbers to Text, showing only the Non-Zero Decimal Places.
16. Append a List of Detail Strings into one Line.
17. Adding a Number of Business Days to a Date
18. How to Print "Continued on Next Page"
19. Finding the Last Friday of the Month
20. Removing the Path from the "File Path and Name" field
21. Find Monday of a specific week (using ISO standard week numbers)
22. Rounding to the nearest nickel, or other odd increment
23. Finding the First Friday of the Month
24. Finding the Number of Fridays in a Date Range
25. How to find Good Friday (or Easter) for any year
26. How to Generate a list of Common Holidays for any Year

Ken Hamady, On-site Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Crystal Reports Formulas
http://www.kenhamady.com/