If date is before 11/1/2017 name column differently

[jark1294]

I'm hoping to take my "Campaign" column and change the name of the line item if the date is prior to 11/1/2017 for a specific campaign.

I tried IF (Contains[campaign],"One+" AND date < 11/1/2017) THEN "Evergreen" ELSE "" ENDIF

But it's saying the date function won't work with a less than symbol. Any tips? Thanks!

[MarqueeCrew · Accepted solution]

@jark1294,

Dates should be in the ISO format of:  YYYY-MM-DD.  The date 11/1/2017 should appear as:  "2017-11-01"

Your formula might appear as:

IF Contains([campaign], "One+" AND [Date] < "2017-11-01"
THEN "Evergreen"
ELSE ""
ENDIF

Cheers,

Mark

[jark1294]

Perfect, thank you!!