Forum Discussion

Stuznet's avatar
Stuznet
Helper V
7 years ago
Solved

Rolling and Trailing Year True False

  Hi,   I've searched around but couldn't find the answer that I'm looking for. Basically, I'm trying to create a calculated column to show the current year and next year which is 2019 and 2020. ...
Need Help
Show and Tell
Tutorial Requests
  • parry2k's avatar
    parry2k
    7 years ago

    Stuznet try this

     

    Column = IF([Year] = YEAR(TODAY()) + 1 || [Year] = YEAR(TODAY()), TRUE(), FALSE())
parry2k's avatar
parry2k
Super User
7 years ago

Stuznet try this

 

Column = IF([Year] = YEAR(TODAY()) + 1 || [Year] = YEAR(TODAY()), TRUE(), FALSE())
  • Stuznet's avatar
    Stuznet
    Helper V
    7 years ago
    Hi parry2k,

    It was that simple and I made it hard. Thank you for your help :)