Skip to main content

Hello,

I am trying to define criteria within a PB (or flow I have tried both) where the criteria is if the year is last year. I have a year field on the object and have been trying a formula to remove one year from that but its not working. 

Some of the options I have tried are:

TEXT(YEAR(TODAY()-1))

TEXT(yearfield_c)-1

 

The year field on the object is a picklist so I even tried creating a 2nd year field on the object that was a formula field and pulling the value from the first year field into this but it is still not working.

 

Any suggestions please? And thanks in advance :) #Process Builder #Flow #Formula Field

2 respuestas
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    18 nov 2021, 12:40 p.m.

    Hi,

     

    You would need something like:

    Picklist - equals - formula - TEXT(YEAR(TODAY())-1)

     

    Bear in mind that the API name of th epicklist values need to be the year exactly, it cannot be different to your label here