Forum Discussion
inglexjc
Post Patron
1 year agoShow column how many days since effective date
Trying to create a column that shows how many days since something was effective. I have a data tabe that gives me
| Agency Name | Client Name | Effecitve Date |
| Test | Jane Doe | 12/23/2024 |
I created a Date Table. But can't seem to get the formula to work to show how many days since the Effecitve Date.
inglexjc
Add this as a Calculated Column to the above table:Days Since Effective Date = INT ( TODAY () - [Effecitve Date] + 1 )