Jump to content

This topic is 7659 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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?

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.