TemplateFill of Gallery

[neill_long]

Hello,

I am trying to add an If statement on the templatefill of my gallery.  I have a field stored in a SP List which is a calculate field, and it displays a date: calculated to show the day before the date entered in another field.

I want to the line to highlight red if this calculated field date is equal to todays date.

On the label in the gallery, I have the following formula to format the date:

Text(DateValue(ThisItem.Student_Add_Date, "en"),"[$-en-GB]dd/mm/yyyy")

On the TemplateFill on the Gallery, I have:

If(Value(ThisItem.Student_Add_Date) = Today(), RGBA(255, 0, 0, 1), RGBA(0, 0, 0, 0))

Can anyone help?

[neill_long · Accepted solution]

I think i was overthinking this and have come up with a different solution:

If(DateAdd(ThisItem.EV_Date, -1) = Today(), RGBA(255, 0, 0, 1), RGBA(0, 0, 0, 0))

this seems to work fine