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!

[sunny_talwar]

There is only one value selected for ReferenceDate?

[joey_lutes]

Correct.

[sunny_talwar · Accepted solution]

Try this:

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

[joey_lutes]

That worked!

Thanks as always!  You're the S-A KING!

[sunny_talwar]

S-A Queen?? What's that??

[joey_lutes]

Set Analysis of course

[sunny_talwar]

S-A King you mean....

[joey_lutes]

  My sincere apologies.  King it is! (very small picture).  I'll update the post accordingly.

Begging forgiveness!!

Thanks again for the help.

[sunny_talwar]

no worries