17 Replies Latest reply: Dec 12, 2016 11:06 AM by Joey Lutes RSS

    Set Analysis comparing 2 date fields

    Joey Lutes

      Can anyone tell me what's wrong with this code? (site.VerifiedDate and ReferenceDate are both date fields in different tables)

       

      Sum({$<site.VerifiedDate={">=$(ReferenceDate)"},site.AddedDate={"<=$(ReferenceDate)"}>}site.Counter)

       

      Date Format has been verified and works

       

      Thanks!