Challenge

Create a formula field, Days_As_Customer that can calculate how many days an Account has been a customer based on the acquisition date:

Prereqs

Create the following field on Account:

Field Type: Date
Field Label: Acquisition Date
Field Name: Acquisition_Date
Description: Captures the date an account became a customer

Create the following field on Account:

Field Type: Formula (Number)
Field Label: Days As Customer
Field Name: Days_As_Customer
Description: Calculates how many days an account has been a customer based on the Acquisition_Date__c

Example Scenarios

Example 1:

Input: Acquisition_Date__c = 09-26-2024, Today = 10-26-2024
Result: Days_As_Customer__c = 30
Explanation: There are 30 days between 09-26-2024 and 10-26-2024

Example 2:

Input: Acquisition_Date__c = 10-26-2024, Today = 10-26-2024
Result: Days_As_Customer__c = 0
Explanation: There are 0 days between 10-26-2024 and 10-26-2024