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

[Roy Keane]

Hello all

I have a document 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 document 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]

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" <royser@hotmail.com> escribió en el mensaje
news:54780adb.0307212340.4e62a26b@posting.google.c om...

> Hello all
>
> I have a document 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 document 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

[james samuel]

This works for me

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