This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello,
I’m trying to create a formula where the value is today’s date minus date of the first invoice:
Today’s date - Date of first invoice = Years doing business
I would need to enter the “Date of the first invoice”. Not sure if I need 2 columns or...
How I got to work:
DATETIME_DIFF({Today’s date}, {Date of the first invoice}, ‘days’)/365
I tried the following, hoping to get decimal, such as 4.5 but result was just 4 or 4.0 or 4.00 (depending on Formatting.):
DATETIME_DIFF({Today’s date}, {Date o...
I’m creating a CRM base and a “Location” filed would be nice. Like Phone and Email it would be nice if this field type had behavior on par with other systems, in that clicking on the address would engage map functionality on phone, etc.
