Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Topic Labels: Formulas
834 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"