Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Reformat Time Field for Access? (A2k (9.0.3821) SR-1)

    Converting a time field from legacy system with the following input from a text field:

    _130 (that

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Reformat Time Field for Access? (A2k (9.0.3821) SR-1)

    First pull out the hours and mins with:
    Hours: Left([timetext],2)
    Mins: right([timetext],2)
    then
    time: IIf(Not IsNull([timetext]),TimeSerial([hours],[mins],0),Null)
    Regards
    John



Posting Permissions

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