Skip to main content

I'm trying to build a formula that returns "true" every 180 days (and subsequent 180 days) after a record was created.  I'm heading down a very complicated route involving dividing  {Days Since Created}/180 and checking the length of the return result.

I'd like to be able to build a "divides exactly" check into this:

DATETIME_DIFF(
NOW(),
{Date Created},
'days'
)

Any ideas would be gratefully received.

Found it in Excel - MOD function returns the remainder after dividing the number. If the result is zero then "true"

Reply


Terms & Conditions