Sep 18, 2009 #1 rbvcbr IS-IT--Management Mar 4, 2007 58 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,
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,
Sep 18, 2009 #2 lbass Technical User Feb 9, 2002 32,816 US 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
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