Date formatting
Date formatting
- Subject: Date formatting
- From: "Eric Phillips" <email@hidden>
- Date: Wed, 24 Apr 2002 13:02:24 -0400
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.