Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

Posted

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.

Posted

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.

Posted

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.

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 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.