crazybake Posted March 12, 2004 Posted March 12, 2004 I have a date field which I have formatted using the "date" menu item. Itshows a date as (i.e.January 24, 1998). I then have a calculation field which contains 2 other text fields and this date field. So, I used the function DatetoText(mydatefield) & text1 & text2. However the date always comes as (1/24/98). How can I keep the long formatting when using the calc field? Version: v6.x Platform: Mac OS X Jaguar
CyborgSam Posted March 15, 2004 Posted March 15, 2004 I don't see that behavior. I'm running the same version of FileMaker and Panther, both use US/English for the language. I defined a date field, entered 2/2/97 in it. I made a calculation field with DateToText() and it always shows 2/2/1997. How I format the date field has no effect on the calc field. Is your calculation field set so the Calculated result is Text?
Recommended Posts
This topic is 7659 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now