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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lowest Date

Status
Not open for further replies.
rbvcbr

rbvcbr

IS-IT--Management
Mar 4, 2007
58
0
0
US
I have date field, I want to show on the report,
start date (lowest date) and end date(latest date).
Need help with formula please.

Something like, 9/1/09 - 9/18/09.

Thanks,
 
Sort by date Sort by votes
minimum({table.date}) & " - " & maximum({table.date})

Or if you want to format them specifically, use:

totext(minimum({table.date}),"M/d/yy") & " - " & totext(maximum({table.date}),"M/d/yy")

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PJ222
  • Locked
  • Question
is date within any date range in a dynamic array of date ranges
Replies
1
Views
71
PJ222
PJ222
ejastia
  • Locked
  • Question
date format spacing 1
Replies
4
Views
77
ejastia
ejastia
sofseattle
  • Locked
  • Question
Crystal formula for barcode display shows extra characters in date format?
Replies
1
Views
103
BobSuruncle
BobSuruncle
chish_nc
  • Locked
  • Question
Need help getting oldest anniversary date to show
Replies
3
Views
91
pmax9999
pmax9999
socalvelo
  • Locked
  • Question
Date Range Formula - Data from two months ago only
Replies
4
Views
121
pmax9999
pmax9999

Part and Inventory Search

Sponsor

Back
Top