Results 1 to 3 of 3

Thread: A nut to crack

  1. #1
    Join Date
    Jan 2003
    Posts
    1

    Question Unanswered: A nut to crack

    I have a field in a access db table called History. this field is a text field and looks like this..(All the text is in one field)

    2002-10-04 Went to CUL for some COM.
    2002-11-02 Problem Solved
    2003-01-11 Installed 2000 Server.

    I want to retrive the last date from the field.. which in this example is
    2003-01-11 ..

    I know how to do it if it where only one row but here it is 3 or more in one field..

  2. #2
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256
    Use the MID or LEFT function to get the date string out of the entire field, convert this to a real date and select the max of the result....
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  3. #3
    Join Date
    Feb 2003
    Posts
    1
    Originally posted by blom0344
    Use the MID or LEFT function to get the date string out of the entire field, convert this to a real date and select the max of the result....
    try this:
    SELECT Max(CDate(Left([Feld1],10))) AS LastEntry FROM Tabelle1;

Posting Permissions

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