DALLASTXPAT Posted February 2, 2005 Share Posted February 2, 2005 I need to add the number of days between today's date and somebody's hire date. Currently I have a field that is not shown on the layout named Current Date. The other field is named Hire Date. The field I want to display the number of days is called Days Employed. I have it set as a number field with a calculation. The calculation is Current Date - Hire Date. What I want is to not be able to change this value and have it perform the calculation. I am lost. I am a newbie to this so please be nice. Link to comment Share on other sites More sharing options...
-Queue- Posted February 2, 2005 Share Posted February 2, 2005 Make it a calculation field with a number result, not a number field with an auto-enter calculation. It must be set as unstored in Storage Options ('do not store') and would probably be easiest to use Get(CurrentDate) instead of referencing a Current Date field, which must also be unstored in order to update. Link to comment Share on other sites More sharing options...
DALLASTXPAT Posted February 2, 2005 Author Share Posted February 2, 2005 Thanks. It worked. Is there not a function named Get(CurrentDate) in FMP7. I couldn't find it. Link to comment Share on other sites More sharing options...
-Queue- Posted February 2, 2005 Share Posted February 2, 2005 Look again. It's listed under the Get functions in the 'view' menu when defining the calculation. Or just type it in manually and it will resolve it. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7023 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