Results 1 to 2 of 2

Thread: Remove text

  1. #1
    Join Date
    Mar 2005
    Posts
    55

    Exclamation Unanswered: Remove text

    I have a field that has the following data

    Hills 13-10-06
    Transport logistic 15-10-06

    How do i extract just the date value from these fields

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    If it's consistent,

    Right(FieldName, 8)
    Paul

Posting Permissions

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