Re: Date object into FMP field
Re: Date object into FMP field
- Subject: Re: Date object into FMP field
- From: Andrew Oliver <email@hidden>
- Date: Thu, 11 Mar 2004 09:37:42 -0800
The only way I've been able to do this is to have the script populate
standard text fields, using a calculation field that returns a Filemaker
Date.
In your script you build a string that contains the date in a known format,
e.g. "3 11 2004". You set the text field in Filemaker to this value.
In the real date field you set the calculation to parse the known text
string using some combination of 'LeftWords()', 'MiddleWords()' and
'RightWords()' and the Date(month, day, year) function.
This approach does have the drawback that since the visible Date field is a
calculation field, users cannot enter their own dates into this field. This
may or may not be an issue for you (and you might be able to get around it
by allowing entry into separate 'day', 'month' and 'year' fields, maybe
using a pop-up menu interface if you like that kind of thing).
Andrew
:)
On 3/11/04 3:26 AM, "Simon Forster" <email@hidden> wrote:
>
I'm working on a project where I have an AppleScript date object which
>
I want to write to a FileMaker Pro date field. Just trying to set the
>
field to the date object fails. I can get the date as a string in the
>
dd/mm/yyyy format that my (UK) version of FileMaker will accept.
>
However, as soon as someone in the US uses this script, it'll fail (or
>
give unexpected results).
>
>
So, what's the preferred way of getting a date into a FileMaker Pro
>
date field? Is there something obvious that I'm overlooking? If not,
>
how can I tell what date format FileMaker is working with?
>
>
TIA
>
>
Simon Forster
>
_____________________________________________________
>
LDML Ltd, 62 Pall Mall, London, SW1Y 5HZ, UK
>
Tel: +44 (0)70 9230 5244 Fax: +44 (0)70 9230 5247
>
_____________________________________________________
>
_______________________________________________
>
applescript-users mailing list | email@hidden
>
Help/Unsubscribe/Archives:
>
http://www.lists.apple.com/mailman/listinfo/applescript-users
>
Do not post admin requests to the list. They will be ignored.
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.