Re: Date formatting
Re: Date formatting
- Subject: Re: Date formatting
- From: Jeff Shapiro <email@hidden>
- Date: Wed, 24 Apr 2002 15:41:41 -0600
Well, the easiest, although not necessarily the best, way is to select the
field in FMP layouts and use a custom date format. The custom formatting in
FMP gives more or less complete control in the way that dates will look. A
better way would be to get Excel to behave properly. Although, that's
something that I haven't been able to do in about 6 years.
On 4/24/02 11:02 AM, "Eric Phillips" <email@hidden> wrote:
>
This question is not directly related to scripting so if someone feels that it
>
is more appropriate to answer offline that is fine. In Excel I have a script
>
that formats a column as text then inserts the file name into that column. The
>
file name is something like April 2001.xls. What I want is just April 2001 so
>
I do a find and replace to get rid of the .xls. When I do this it converts the
>
text to a date. I can format the date to say April 2001 but I want to import
>
this file into FMP and the date becomes 4/1/01. The end goal is to have FMP
>
show the field as April 2001. If it does that as a date or as text I don't
>
care. Does anyone have suggestions on how to keep Excel from changing the
>
format to a date or have FMP express the date as April 2001?
>
>
Thanks,
>
Eric
>
_______________________________________________
>
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.
---
Jeff Shapiro
Photography and Graphic Design
719.330.8333
Colorado Springs, CO
http://www.nensha.com |||||
mailto:email@hidden
(nensha -- Japanese -- spirit photography)
_______________________________________________
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.