Professional Web Applications Themes

Changing to British date form a US style (text) field - FileMaker

Hello all I have a doent tracking database set up in FM Pro. One of the fields I use is a "Due Date" field which is scripted to add two days to the current date. Our printed product is required within two days of origination. Sometimes this needs to be an extra day or two as it may fall on a friday. As a result I have used a free calendar file which pops up and once a date is selected the result is placed in a global text field, I have scripted the the ok button in the calendar ...

  1. #1

    Default Changing to British date form a US style (text) field

    Hello all

    I have a doent tracking database set up in FM Pro. One of the
    fields I use is a "Due Date" field which is scripted to add two days
    to the current date. Our printed product is required within two days
    of origination. Sometimes this needs to be an extra day or two as it
    may fall on a friday.

    As a result I have used a free calendar file which pops up and once a
    date is selected the result is placed in a global text field, I have
    scripted the the ok button in the calendar to place it on the
    clipboard. Then going back to my doent tracking database I have
    inserted a button that pastes the result in the Due Date window.
    However it is in the US format (i.e. MM/DD/YY). What scripting actions
    can I use to change this back to British format (i.e. DD/MM/YY)?
    Remember the field is a text field seeing as it has been copied from a
    text field. Can I use a text command to swop the month with the date
    format? I have tried using date filed settings but I get an error
    warning asking me to Revert.

    Regards

    Royser
    Roy Keane Guest

  2. #2

    Default Re: Changing to British date form a US style (text) field

    Well,

    you can make a field named BRITISH DATE as calc field and the sentence will
    be:

    MiddleWords( US DATE; 2; 1) & "/" & LeftWords( US DATE; 1) & "/" &
    RightWords( US DATE; 1) and calculation result must be as TEXT.

    Sorry, maybe this is not a solution for your problem but... my Englsih is
    too bad.

    Regards,

    JC

    "Roy Keane" <royserhotmail.com> escribió en el mensaje
    news:54780adb.0307212340.4e62a26bposting.google.c om...
    > Hello all
    >
    > I have a doent tracking database set up in FM Pro. One of the
    > fields I use is a "Due Date" field which is scripted to add two days
    > to the current date. Our printed product is required within two days
    > of origination. Sometimes this needs to be an extra day or two as it
    > may fall on a friday.
    >
    > As a result I have used a free calendar file which pops up and once a
    > date is selected the result is placed in a global text field, I have
    > scripted the the ok button in the calendar to place it on the
    > clipboard. Then going back to my doent tracking database I have
    > inserted a button that pastes the result in the Due Date window.
    > However it is in the US format (i.e. MM/DD/YY). What scripting actions
    > can I use to change this back to British format (i.e. DD/MM/YY)?
    > Remember the field is a text field seeing as it has been copied from a
    > text field. Can I use a text command to swop the month with the date
    > format? I have tried using date filed settings but I get an error
    > warning asking me to Revert.
    >
    > Regards
    >
    > Royser

    JC Guest

  3. #3

    Default Re: Changing to British date form a US style (text) field

    This works for me

    Date (
    LeftWords ( Substitute ( USDate ; "/" ; " " ) ; 1 );
    MiddleWords ( Substitute ( USDate ; "/" ; " " ) ; 2 ; 1 ) ;
    RightWords ( Substitute ( USDate ; "/" ; " " ) ; 1 ) )
    james samuel Guest

Similar Threads

  1. Question changing font size in a form field that auto-selects text size
    By Unregistered in forum Brainstorming Area
    Replies: 0
    Last Post: June 19th, 04:18 PM
  2. Changing a Flash form field value
    By AcidMatt in forum Coldfusion Flash Integration
    Replies: 0
    Last Post: November 18th, 04:08 PM
  3. Converting a text field to a date field - FM6
    By Carl Mittler in forum FileMaker
    Replies: 2
    Last Post: October 17th, 09:38 PM
  4. Changing Style In Form
    By Les in forum Microsoft Access
    Replies: 1
    Last Post: July 22nd, 10:33 PM
  5. Linking date field to text field entry
    By Trey in forum Microsoft Access
    Replies: 1
    Last Post: July 16th, 07:35 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