Good day all,
I've been experimenting with the Diff Past Month functionality in a widget to track our On Account funds. But rather than a "rolling month" (or "a month from today" which I think is what i get with this formula), I'm looking for a difference from a fixed date, so for example 8/31/21.
Is that possible?
Thanks!
Lesley
Nathanael Pearson I saw your note above about telling Analytics to "get today's date", were you able to dig that up? I'm trying to set up a function that will update some hardcoded benchmark goals on the first of the month in a contributions (i.e. if current month = 7, then return 6000, if current month = 8, then return 7000) and right now I only seem to be able to use date fields that are linked to contributions (which is not ideal, since with the overnight load and our gift processing timelines, the "current month" of the most recent contribution may be behind by a couple days). Appreciate any insight you might have!
I might have made some progress, but it's hard to tell - I'm a few large steps beyond my usual realm with this stuff! I'm basing this on Anastasia's formula above.
IF ( ( MAX ( DDIFF( [Perf Date] , NOW ( [Perf Date] ) ) ) ) = 0 , 2 , 0)
When I use this as a value, it returns 7/29 as '2', and everything else as '0'. This seems to indicate that the formula is asking 'If the difference between the performance date and ( TODAY ) is 0, enter 2, otherwise 0.' In other words 'if the performance date is TODAY, give me '2', otherwise give me '0' '.
I think I did something, but I'm not sure if I did anything. Does this help? IT seems to recognize 'Now' as (Today) and filters it by the measure I gave it.
Chris Wallingford am I on the right track? At least a track?