mac_g4 Posted May 7, 2006 Share Posted May 7, 2006 Can anyone tell me how to make a date field show the current date in every record. The use for this is to show the number of days that have passed since an invoice was issued by using a calculation field to show "Current date - Invoice date". Thanks. Link to comment Share on other sites More sharing options...
mz123 Posted May 7, 2006 Share Posted May 7, 2006 You can make a calculation field: Get(CurrentDate) That should do it Martha Link to comment Share on other sites More sharing options...
Lee Smith Posted May 7, 2006 Share Posted May 7, 2006 Be sure to Unstore the calculation. Lee Link to comment Share on other sites More sharing options...
mac_g4 Posted May 7, 2006 Author Share Posted May 7, 2006 Thanks Martha, that did the trick. Lee, how do you Unstore the calculation. Thanks. mac_g4. Link to comment Share on other sites More sharing options...
Lee Smith Posted May 7, 2006 Share Posted May 7, 2006 Define Fields >> Storage Options >> Select the "Do not store calculated results -- recalculate when needed. HTH Lee Link to comment Share on other sites More sharing options...
mac_g4 Posted May 8, 2006 Author Share Posted May 8, 2006 Thanks Lee. Got there in the end. mac_g4 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6562 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