Button Background change based on selection

[cgT]

Hi there,

I'm trying to use the following expression to format the background of a button based on expression:

=if(TransactionDate = '>=$(=WeekStart(Today() - 7))<=$(=WeekEnd(Today() - 7))', '#f3f4f6', '#ffffff')

It's important that the dynamic selection is what drives the change in background colour, however this doesn't seem to be working.

Can anyone help please?

Thank you in advance,

[Kushal_Chawda]

@cgT   seems you are using set expression condition in if statement. tyr below

=if(TransactionDate >= WeekStart(Today() - 7) and 
TransactionDate <= WeekEnd(Today() - 7), '#f3f4f6', '#ffffff')

[cgT]

Thanks for the speedy reply, Kushal.

Unfortunately it doesn't seem to work. I click the button with this in place and nothing changes in terms of the button's appearance.

[cgT · Accepted solution]

I have now solved this using variables, but thank you for offering up a solution.