
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 17, 2023 09:50 AM
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

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 17, 2023 10:13 AM
Found it in Excel - MOD function returns the remainder after dividing the number. If the result is zero then "true"
