This article is outdated.
We have moved our support docs to a new location.
Please click here to go to our new support docs.
Date Formula Fields are fields with automatically generated values based on a defined formula. These fields can reference other date type values in their formula.
- Select the format for the values of your field.
- Add the date type value from a field in your record, an operation, or a custom value.
- Reorder or Delete components
- Preview your formula.
Let's take a look at an example of the difference between two Date/Time Fields showing results in the formats for Day, Hour, and Second. We'll show an additional example for the Date format as well.
For the first three formats, we'll use the following formula where D1 and D2 are Date/Time Fields.
These are the values that we have set for D1 and D2.
With the same formula configured for each, we have three results showing the different formats Day, Hour, and Second. For the Hour format, you are able to select from options to show minutes and seconds as well.
For our second example showing the Date format, we'll create a new formula utilizing a custom value. When adding a custom value, you may define the value or utilize a numeric field. Additionally, you may define the format representing the increment of time that is to be used for the custom value. In this case, we will define the numeric value and use the Day format.
With the same value for D1 as defined in our previous example, we have the following result.
With a form and a table component on a page for our example, we can observe the Date Formula values are populated automatically.