Alpha Video Training
Results 1 to 3 of 3

Thread: changing field types

  1. #1
    Member mwreed's Avatar
    Real Name
    Mike Reed
    Join Date
    Oct 2005
    Location
    West Palm Beach, Florida
    Posts
    11

    Default changing field types

    I have a data base with a "Character" field that we enter a date in, as: mm/dd/yr, with a template: / /.

    I would like to change this field to a "Date" field, "mm/dd/yr", but need to maintain the pre existing data (dates) in this field, when it is converted. Is this possible?

  2. #2
    "Certified" Alphaholic Mike Wilson's Avatar
    Real Name
    mike wilson
    Join Date
    Apr 2005
    Location
    Grand Rapids, Michigan
    Posts
    4,198

    Default Re: changing field types

    Mike,
    Yes, you can just change the type. You might like to try creating a new field -- newdate --, set it as a date field and in the field rules make it a calculated field with the expression CTOD(datefieldname,"1/"). Then highlight the table in the Control panel, right mouse click, and select Utilities>recalculate field rules. This will fill the Newdate field with the data from the character field. CTOD is Character-TO-Date.

    Mike W

  3. #3
    Member mwreed's Avatar
    Real Name
    Mike Reed
    Join Date
    Oct 2005
    Location
    West Palm Beach, Florida
    Posts
    11

    Default Re: changing field types

    That does it, thanks for the quick reply.

Similar Threads

  1. Field Types Don't Match
    By debwelch in forum Alpha Five Version 6
    Replies: 5
    Last Post: 12-22-2010, 08:54 AM
  2. Appending literal or changing fld types
    By Jerri Butts in forum Alpha Five Version 1
    Replies: 2
    Last Post: 04-19-2005, 05:21 AM
  3. Field types
    By Richard Froncek in forum Archived Wishlist
    Replies: 3
    Last Post: 02-11-2005, 10:44 AM
  4. Importing into MEMO field types
    By Willie Sagulo in forum Alpha Five Version 6
    Replies: 7
    Last Post: 09-23-2004, 02:51 PM
  5. Memo Field Types
    By Ryan Giggs in forum Alpha Five Version 5
    Replies: 5
    Last Post: 04-17-2004, 05:39 PM

Bookmarks

Posting Permissions

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