Help

Formula returns "true" if number field divides exactly by 180

Topic Labels: Formulas
445 1
cancel
Showing results for 
Search instead for 
Did you mean: 
BobH
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Reply 1
BobH
5 - Automation Enthusiast
5 - Automation Enthusiast

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