DALLASTXPAT Posted February 2, 2005 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.
-Queue- Posted February 2, 2005 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.
DALLASTXPAT Posted February 2, 2005 Author Posted February 2, 2005 Thanks. It worked. Is there not a function named Get(CurrentDate) in FMP7. I couldn't find it.
-Queue- Posted February 2, 2005 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.
Recommended Posts
This topic is 7233 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