Apex Code Development You need to sign in to do that
Don't have an account?
Estée Chao Need to create a formula field that determines the number of days between the end date of a contract and today. Help! Womp.
Hello all!
I am working on the 'Use Formula Fields' module and the challenge have me stumped. The challenge is:
"Create a formula field that determines the number of days between the end date of a contract and today." With the following requirements:
Object: Contract
Formula Return Type: Number
Field Label: Days Remaining
Field Name: Days_Remaining
Field Level Security: Visible and Read-Only for all profiles
Add the field to the standard Contract Layout page layout
The formula should return the number of days between the contract end date and today
The resulting API name for the field should be Days_Remaining__c
I have been consistently getting the error:
"There was an unexpected error in your org which is preventing this assessment check from completing: System.DmlException: Insert failed. First exception on row 0; first error: FIELD_CUSTOM_VALIDATION_EXCEPTION, Account number must be 8 characters long.: []"
Help would be much appreciated fellow developer wizards! Thanks!!
I am working on the 'Use Formula Fields' module and the challenge have me stumped. The challenge is:
"Create a formula field that determines the number of days between the end date of a contract and today." With the following requirements:
Object: Contract
Formula Return Type: Number
Field Label: Days Remaining
Field Name: Days_Remaining
Field Level Security: Visible and Read-Only for all profiles
Add the field to the standard Contract Layout page layout
The formula should return the number of days between the contract end date and today
The resulting API name for the field should be Days_Remaining__c
I have been consistently getting the error:
"There was an unexpected error in your org which is preventing this assessment check from completing: System.DmlException: Insert failed. First exception on row 0; first error: FIELD_CUSTOM_VALIDATION_EXCEPTION, Account number must be 8 characters long.: []"
Help would be much appreciated fellow developer wizards! Thanks!!
All Answers
Please mark best answer
Result = Number
Formula = TheDateField__c - TODAY()
The 'Days_Remaining__c' formula field did not return the correct number of days between the contract end date and today.