Hey there,
I’ve already converted my array into a string, and each value is separated by a comma. It looks like this:
2019-12-23T00:00:00.000Z, 2019-11-23T00:00:00.000Z, 2019-12-27T00:00:00.000Z, 2019-11-
23T00:00:00.000Z, 2019-11-24T00:00:00.000Z
...
Hey there,
I have a list of records that include a “Link” field that contains multiple records from a separate table. Each one of these records within the “Link” field contains a field with a date. I have used a rollup field to determine all of the d...
Well this was the formula I tried within that rollup of dates:
if(DATETIME_DIFF(values, {Opt-in Timestamp}, 'days') < 1, "0", "1")
I was only given one output, instead of the expected multiple outputs, considering I have multiple days.
Awesome, this is really helpful thank you! I’m really close to making this thing work.
So how would I go about doing this calculation for all of the values at once? In your example you show Date A and Date B, but my function would be more like IF(DAT...
So I want to get the DateTimeDiff between the “Link Date” and “Opt-In Date” (another date field I have).
If DateTimeDiff < 1 do X
If DateTimeDiff > 1 do X
I understand how to do the IF statements, but I am unsure as to how I would get a count of the ...
