Skip to main content

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

  • March 17, 2023
  • 1 reply
  • 1 view

Forum|alt.badge.img+5
  • New Participant
  • 4 replies

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

Forum|alt.badge.img+5
  • Author
  • New Participant
  • 4 replies
  • March 17, 2023

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


Reply