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.