At the moment, we are successfully using vLookup with the 2 filters, but would like to have 3 filters, so we know we need a CAML query to override the default filtering.
Here is what we are after for our filters:
Where Associate_x0020_Name = [currentItem:Associate_x0020_Name]
Defect_x0020_Type = currentItem:Escalation_x0020_Category
(now this is the part we need help on)
Defect_x0020_Date = within the last 12 months ([today] – 360 days?)
How do we do this in CAML? I’m not sure how to format the date column in the CAML query or if it needs to be [today] or now(), etc…
Thank you for this, it worked great! It was the Today OffsetDays= that was eluding us. The other fields in the query are just single line of text, so pasting in what you gave was all that was needed. Wish it was all that easy. 🙂 Thank you!