Print Page | Close Window

Most Recent Date

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23047
Printed Date: 14 May 2024 at 4:57pm


Topic: Most Recent Date
Posted By: andyp
Subject: Most Recent Date
Date Posted: 01 Nov 2023 at 1:19am
Good morning, an employee is attached to a particular cost centre code in our org. If they move to different department they are attached to new cost centre code.
Cost centres and the effective date are stored in two separate tables.
I have tried to use Maximum({Eff_Date}) but this gives the error "Boolean required"
I have a group for the cost centre code and one for the effective date but I cant seem to get a formula working using "Maximum" Does anyone have experience with this?



Print Page | Close Window