Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009
    Location
    Fremont, Ohio
    Posts
    3

    Question Unanswered: getting max(date) in a view

    I have a View with the following code:

    SELECT
    ID, CaseNumber1, DateFiled, OpenActionCode, JudgeNumber, TermDate, TermActionCodeID, ReOpenedCase, VisitJudge, CaseTypeNumber, SubmittedDate, RulingDate,
    PreviousFileDate, Note, CDatefiled, CTermdate, CSubmittedDate, CRulingDate
    FROM
    tblSupremeCourt
    WHERE
    TermDate IS NULL OR TermActionCodeID = 'U' OR TermActionCodeID = 'B' OR TermActionCodeID = 'X'
    ORDER BY
    CaseNumber1



    I have a CaseNumber that has two records in tblSupremeCourt
    CaseNumber1~~~~~TermDate~~~~~TermActionCodeID
    00CV000773~~~~~~2002-08-15~~~~~~X
    00CV000773~~~~~~2003-01-23~~~~~~S

    Currently the record with the TermActionCodeID of X displays in the view, but I don't want it to be displayed because it has a later TermDate.

    Could someone please Help, Thanks!

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    FYI - Cross-posted here Selecting the max date from view
    Testimonial:
    pootle flump
    ur codings are working excelent.

Tags for this Thread

Posting Permissions

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