Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Service Anniversary calculation
I ran into a problem when you are at the end of the year but need the dates from the start of the new year, Dec 30 to Jan 4 for example. I created a formula, @START DATE, to determine the difference: Whileprintingrecords; datepart ("y", {DATE_FIELD}) - datepart("y",currentdate) This give the...- pshimkus
- Post #6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Service Anniversary calculation
OK, thanks. If both dates were in the same year, it is easy. Taking into the different years is what threw me. Thanks! Peter- pshimkus
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Service Anniversary calculation
Hi, I'm running Crystal 11 and need to do a simple calculation. I need to show when an employee's service date or birthdate is within 7 days of running the report. I need to use only the Month and Date not the year. Any Date Difference formula I can think of use the year. This should be...- pshimkus
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 1 Formulas
