Hi, I'm trying to create an expression in a ...

[Terry_Jacob]

Hi,

I’m trying to create an expression in a slice but it doesn’t seem to let me use an apostrophe. This is my expression:

AND([DATE] = <TODAY(), [PROMOTION]=Gus’s Market)

I get this error message:

Expression ‘AND([DATE] = <TODAY(), [PROMOTION]=Gus’s Market)’ could not be parsed due to exception: Number of opened and closed parentheses does not match.

Is it not possible to use an apostrophe in an expression?

[Phil]

@Terry_Jacob

Try quoting the string value

AND([DATE] = <TODAY(), [PROMOTION]=“Gus’s Market”)

[Terry_Jacob]

@Philip_Garrett_Appsh That worked. Thanks for your help.