This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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 ...