topic Re: Simple If Contains Statement in App Development

Simple If Contains Statement

ltc — Tue, 16 Oct 2018 03:43:11 GMT

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 — Tue, 16 Oct 2018 10:09:14 GMT

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 — Wed, 14 Nov 2018 20:51:48 GMT

Why can't you just do

=Year([date field])

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

jayanttibhe — Thu, 15 Nov 2018 20:21:17 GMT

We can remove the nested If statements altogether ...

Try below ::

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