How can I automatically change the
format from date to text in FileMaker 11
?, I could not find any script to do so.

Thanks for the help.

Gaston

In article <8cre16F53dU1 (AT) mid (DOT) individual.net>, gaston62
<gaston (AT) guiaslux (DOT) com> wrote:

It depends on how you want that text version of the date formatted.

If you simply want the date in the stored format (ie. dd/mm/yyyy or
mm/dd/yyyy), then I think it's the Get function in newer versions of
FileMaker.

If you want the text versions specifically formatted, then you'll have to
create your own conversion calculation. For example, to get the text as
"15 March, 2010" you woulld need to use a calculation something like:

= Day(DateField)
& " "
& MonthName(DateField)
& ", "
& Year(DateField)


Helpfull Harry )

On 2010-08-15 17:11:29 -0700, gaston62 <gaston (AT) guiaslux (DOT) com> said:

It's not a script, it's a function:

GetAsText(Fieldname)

Or change the field type in the field definition, if that's what you mean.

Or if you want to change the date format only, select the date field,
Control-click on it, and from the contextual menu, select "Date
Format." This is also under the Format menu.

You can select a pre-configured date format, such as "Dec 22, 2010" or
make your own custom format right there, no calculation necessary.
--
Lynn Allen
--
www.semiotics.com
Member FBA
FM 10 Certified Developer

Thank you very much to both of yours.

Gaston


On 15/08/2010 21:29, Lynn Allen wrote: