New Spark Update 2 12.28 Date_ADD function not working

Sam BeckerSam Becker ✭✭✭
edited June 25, 2020 in Questions
Hello, I'm trying to use the new DATE_ADD function that is listed in the 12.2.8 Spark Notes. I just upgraded our sf production environment to this update.

I don't see the function listed in the formula functions, so I'm not sure it's even there. But, I also tried to use it manually and nothing is happening. I'm using API v1. Here's excerpt from Release Notes and then my code.


New formula functions: DATE_ADD and DATE_DIFF

Working with dates can be a complicated process, so we’ve added two new functions to simplify things:

DATE_ADD is used to take a source date, add a specified amount of time to it, and return a new date. For example, you could add fifteen minutes, two weeks, five months, and so on.

DATE_ADD( {{MyDate}}, 1, WEEK )

You can even subtract time from a date by using a negative integer with the formula.

DATE_DIFF is used to calculate the difference between two dates. You can find out how many minutes, weeks, months, and so on between two dates—whether a specific date or the current date—with this function.

DATE_DIFF( {{MyDate}}, {{MySecondDate}}, DAY )

My Code

DATE_ADD({{AcctSeed__Date__c}}, 30, DAY)


  • Ben MarshallBen Marshall ✭✭✭
    edited November 21, 2019
    Hi Sam, I just double-checked on this. This is currently only available with our V2 components.
  • Sam BeckerSam Becker ✭✭✭
    edited October 16, 2019
    Gotcha. Thanks for the quick reply!
  • Pat VachonPat Vachon 💎💎💎
    edited June 25, 2020
    So unfortunate. Exactly what I needed. Why not have this in V1? At the very least update the docs to exclude these features from V1.
  • Anna WiersemaAnna Wiersema 🛠️ 
    edited June 8, 2020
    Thanks for your feedback here, Pat. We've logged your feedback on the the documentation.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!