Simple If Contains Statement

[ltc]

Hello,

I have a simple statement that I need help with.

If [date] field contains '2016', then display as '2016'

If [date] field contains '2017', then display as '2017'

If [date] field contains '2018', then display as '2018'

How do I properly write this up as one expression?

Thanks!

[Anthony_Ventura · Accepted solution]

You can enter the following as a chart expression:

=if(OrderDate like '*2016*','2016',

     if(OrderDate like '*2017*','2017',

          if(OrderDate like '*2018*','2018','Other')))

[ogster1974]

Why can't you just do

=Year([date field])

Not sure why you'd need an IF statement for this requirement.

[jayanttibhe]

Hi 

We can remove the nested If statements altogether ... 

Try below :: 

Pick(wildmatch(OrderDate,'*2016*','*2017*','*2018*',OrderDate),2016,2017,2018,'Other')