Syntax help Dates..

[vffdd]

I'm looking for some syntax help just can't seem to get it right so thought I'd ask the experts who generally resolve my issues very quickly ! 😀

I have sharepoint list with a Date Picker Field called ExpiryDate.

I have a gallery which pulls from that data source and it has a Date Picker Field called  CalcExpiry (it calculates based on other factors)

I want to add another field in my gallery that looks at ExpiryDate if there is something there it uses that.. if not it uses CalcExpiry

I'm not sure A) whether to use a label or a DP field  for this new field? and B)  having tried both I just can't get the right syntax !!  Here's what I currently have which seemed logical !  but it's errors all over the place 😀

If(IsBlank(ThisItem.ExpiryDate,DPCalcExpiry.SelectedDate,ThisItem.ExpiryDate))

Have tried switching things around but can't hit on the right one !

Any help gratefully received

TIA

[vffdd · Accepted solution]

Fixed !!  

I had closing bracket in the wrong place

If(IsBlank(ThisItem.ExpiryDate),CalcExpiry.SelectedDate,ThisItem.ExpiryDate)

🙄