Forum Discussion

inglexjc's avatar
inglexjc
Icon for Post Patron rankPost Patron
1 year ago
Solved

Show 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 NameClient NameEffecitve Date
TestJane Doe12/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 )

1 Reply

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User

    inglexjc 

    Add this as a Calculated Column to the above table:

    Days Since Effective Date =
    INT ( TODAY () - [Effecitve Date] + 1 )