1

I am trying to set a formula based criteria on process builder:

(TODAY() = DATEVALUE(2016,11,29))

Trying to say that on a specific date, it should fire the subsequent actions. Am I entering the date correctly? Is there a better way to do this?

1 Answer 1

1

This is a good way.

DATEVALUE expects to be like that: 'YYYY-MM-DD', so your date should be like this:

TODAY() = DATEVALUE('2016-11-29')

6
  • Would it be TODAY() = DATEVALUE('2016-11-29' OR '2016-11-30) if I wanted to add multiple dates? Nov 30, 2016 at 1:45
  • OR(TODAY() = DATEVALUE('2016-11-29'), TODAY() = DATEVALUE('2016-11-30')) Nov 30, 2016 at 6:32
  • I tried to the OR function, the process will evaluate on the first date but it will not evaluate on the second date. Why is that? Dec 8, 2016 at 5:11
  • OR means if one of the values are true, so maybe if the first is true it does not need to check the other ones because the whole formula would return true Dec 8, 2016 at 5:23
  • So would it be AND? That wouldn't work because you can't have two dates as TODAY(), or can you? Basically, I need the process to run on specific multiple dates, that is every year it needs to run. Dec 8, 2016 at 5:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.