Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Carmarthen
    Posts
    5

    Exclamation Unanswered: Urgent Please Help Return Most Recent Date!

    Hi

    Any chance i can please please have some urgent help?

    My problem is that i have a table that has one column which contains a date, I want to be able to have a query that returns just the most recent date, can anyone please let me know what i have to put in the criteri part of the query to return this value?

    many thanks

    Dwayne

  2. #2
    Join Date
    Apr 2003
    Posts
    12

    Most Recent Date?

    Try something like this.

    SELECT Max([date_field]) AS ex_my_date
    FROM any_table;

    This will return the maxium date you have in the field (date_field).

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Or ... SELECT TOP 1 TheDateIWant FROM MyTableWithDate ORDER BY TheDateIWant DESC;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •