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

Pick max date from a table

Status
Not open for further replies.

Lironcareto

Programmer
Oct 27, 2010
1
ES
Hi everyone
I have a table of log data (LogTable) with some columns storing different metrics and another column storing the LogDate. I'd like to pick just the most recent log data, but I cannot use a prompt on the LogDate attribute since I don't know the values of the date column (the user cannot browse the DB table)

All info I've seen similar to this matter use ApplySimple to prompts but I need the max(datecolumn) to be selected automatically.

Any idea?
Thanks a lot in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top