Results 1 to 2 of 2

Thread: Split values

  1. #1
    Join Date
    Jul 2006
    Posts
    157

    Unanswered: Split values

    Hi:
    Can any one please tell me how to i separate date from that string.

    mdate
    yyyy-mm-dd
    2006-11-06-09-58-22
    2006-11-07-15-34-08
    2006-11-08-18-59-01

    Thanks.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    mydateval=cdate(left$(<mydatecol>,10)
    *mytimeval=ctime(mid$(<mytimecol>,9)

    not sure about ctime, am away from the Access Box (yet again....) so its not tested.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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