Professional Web Applications Themes

Converting a text field to a date field - FM6 - FileMaker

I need to convert a Text field containing both auto and manually entered dates over to a Date field. The records that were autoentered move over without a problem. But those that were edited or entered manually using a two digit year do not. For example: 1/25/02 converts to 1/25/1902. Is there any workaround to solve this problem short of manually correcting the converted data. Thanks Carl...

  1. #1

    Default Converting a text field to a date field - FM6

    I need to convert a Text field containing both auto and manually entered
    dates over to a Date field. The records that were autoentered move over
    without a problem. But those that were edited or entered manually using a
    two digit year do not. For example: 1/25/02 converts to 1/25/1902. Is
    there any workaround to solve this problem short of manually correcting the
    converted data.
    Thanks
    Carl


    Carl Mittler Guest

  2. #2

    Default Re: Converting a text field to a date field - FM6

    if(
    year(DateField)<1920,
    date(month(DateField), day(DateField), year(DateField)+100),
    DateField)

    This will obviously take any year before 1920 and add a century to it.
    If you might legitimately have data with the year 1920, then you'll need
    to find the year cutoff that works for you.


    Carl Mittler wrote:
    > I need to convert a Text field containing both auto and manually entered
    > dates over to a Date field. The records that were autoentered move over
    > without a problem. But those that were edited or entered manually using a
    > two digit year do not. For example: 1/25/02 converts to 1/25/1902. Is
    > there any workaround to solve this problem short of manually correcting the
    > converted data.
    > Thanks
    > Carl
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Howard Schlossberg (818) 883-2846
    FM Pro Solutions Los Angeles, California
    Associate Member, FileMaker Solutions Alliance

    Howard Schlossberg Guest

  3. #3

    Default Re: Converting a text field to a date field - FM6

    Carl Mittler <cmdeskoptonline.net> wrote:
    > Is
    > there any workaround to solve this problem short of manually correcting the
    > converted data.
    a calculated "replace all" inserting "20" if the omega-3 character is
    "/"

    to test carefully !
    --
    Philippe Manet
    manet Guest

Similar Threads

  1. Date comparison in a text data field
    By Ad Bec in forum Coldfusion Database Access
    Replies: 5
    Last Post: September 30th, 02:29 AM
  2. Date text Field
    By Darren Woodbrey in forum ASP Database
    Replies: 2
    Last Post: July 16th, 03:17 AM
  3. Replies: 3
    Last Post: September 19th, 05:01 PM
  4. Linking date field to text field entry
    By Trey in forum Microsoft Access
    Replies: 1
    Last Post: July 16th, 07:35 PM
  5. date in text field
    By Dwayne Epps in forum Adobe Dreamweaver & Contribute
    Replies: 0
    Last Post: July 9th, 09:02 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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139