Newbies klrstix Posted September 25, 2006 Newbies Share Posted September 25, 2006 I am having a Problem in FM 6 Developer with a date calculation. The problem is as follows: I have two date fields which are both user entered fields and native to the same record. I have a third field (also native to the same record) that calculates the difference in years between the two previously mentioned date fields. The problem I have encountered is that the calculation only updates when the information is updated in the second date field. I can update the information in the 1st date field all day long and the calculation field will not display updated results. Has anyone encountered this problem? Thanks. Link to comment Share on other sites More sharing options...
Lee Smith Posted September 25, 2006 Share Posted September 25, 2006 If I'm understanding you correctly, it sounds like the calculation is being stored. Go into [color:blue]Define Fields, select the [color:blue]Calculation Field, click on [color:blue]Storage Options, and then [color:blue]Storage, and the Select the [color:red]Do not store calculation results. HTH Lee Link to comment Share on other sites More sharing options...
Newbies klrstix Posted September 25, 2006 Author Newbies Share Posted September 25, 2006 That did not resolve the problem. This problem has me scratching my head! Link to comment Share on other sites More sharing options...
comment Posted September 25, 2006 Share Posted September 25, 2006 Well, you could post the calculation. Or, we could just sit here quietly staring at the problem. Link to comment Share on other sites More sharing options...
Newbies klrstix Posted September 25, 2006 Author Newbies Share Posted September 25, 2006 Calc is as follows: Year(Today_Date)-Year(Contract_Date) Both Today_Date and Contract_Date are user entered date fields. When I update the date in Contract_Date, the calculation updates. When I update the date in the Today_Date field, nothing changes in the calculation field. How weird is that! Link to comment Share on other sites More sharing options...
BobWeaver Posted September 25, 2006 Share Posted September 25, 2006 Is Today_Date a global? I'm guessing that it is, and I'm also guessing that the field that your calculation belongs to, is not set up as an unstored calculation field. It's either a regular field with an autoenter calculation, or a stored calculation field. Link to comment Share on other sites More sharing options...
comment Posted September 25, 2006 Share Posted September 25, 2006 I think that a calculation would be forced to unstored if referencing a global. And in version 6 auto-enter would not update at all. I'd suggest you create a new file with only those three fields and see if you can reproduce the problem. If yes, post the file. If not, I would suspect your current file may be corrupted. Though I never heard of corruption exhibiting such symptom. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6550 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