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!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Maximum

Status
Not open for further replies.
hpl2001

hpl2001

Programmer
Dec 18, 2001
105
CA
I am writing a formula where I would like the formula to return the latest of four dates. Is there a function I can use that would work like:

latest(date1,date2,date3,date4)

TIA.

Holly
 
Sort by date Sort by votes
Try something like:

maximum([currentdate, currentdate -1,currentdate-2,currentdate-3])

Replacing the currentdates with your four fields.

-k
 
Upvote 0 Downvote
Thanks! That's the syntax I was looking for.

Holly
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

-cush-
  • Locked
  • Question
Take Sum from Group 2 and put Maximum in Group 1
Replies
6
Views
104
-cush-
-cush-
jannoth
  • Locked
  • Question
CRXI - Maximum of Formula
Replies
2
Views
83
jannoth
jannoth
jpeters01
  • Locked
  • Question
Trying to display Maximum date records - Crystal XI
Replies
9
Views
137
CrystalizeCanada
CrystalizeCanada
kc27
  • Locked
  • Question
Need to Deterime Maximum Value of a Field Less One
Replies
2
Views
53
kc27
kc27
MochaLatte
  • Locked
  • Question
Average Difference Maximum Group
Replies
3
Views
59
pmax9999
pmax9999

Part and Inventory Search

Sponsor

Back
Top