Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

The calculation works for me, are you sure the date field is a "date" type filed?

The calculation for 2/6/2006 returns 1

HTH

Lee

Posted

It keeps coming up "1st Quarter 0001" no matter the date change.

The result indicates that the referenced Date field is empty (and that the calculation is set to evaluate when all referenced fields are empty).

Posted

It keeps coming up "1st Quarter 0001" no matter the date change.

Sounds like you've set it as a date field instead of number field result.

Posted (edited)

I have tried all of that. Never get "1st quarter 2005"

Since the zip is 2.5 megs and too large for uploading here. Here is the link. Link It is on the "State Mileage" form. Access thru the Master Navigator.

Any help is appreciated.

Edited by Guest
Posted

You are not supposed to get "1st quarter 2005". You are supposed to get either 1 or 2 or 3 or 4. You will, if you set the result of the calculation to Number.

If all you want is to display "1st quarter 2005", then duplicate the Date field on the layout, go to Format > Date..., select Custom and format it the same way you have formatted the Quarter field. You can then delete the Quarter field from your file - it's not needed.

Posted

Change the Field Type to NUMBER

Go into layout mode and reformat the number as General, currently it is formated as dollars.

Lee

This topic is 6927 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.