you can make a field named BRITISH DATE as calc field and the sentence will
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
"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.