separte date and time

Results 1 to 2 of 2

Thread: separte date and time

  1. #1
    8575 Guest

    Default separte date and time

    I have one field in a table that stores the date fomatted like this 6/23/2000 19:00:00.<BR>I&#039ve created to separate fields for date and time. Does anyone know how I can separate the current data into the different new fields without having to cut and paste each one?

  2. #2
    Join Date
    Dec 1969

    Default RE: separte date and time

    Are you using MS Access? You can do a make table query and set the field property to date or time with the format you want.

Posting Permissions

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