Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try this:
Sum({$<site.VerifiedDate={">=$(=ReferenceDate)"},site.AddedDate={"<=$(=ReferenceDate)"}>}site.Counter)
There is only one value selected for ReferenceDate?
Correct.
Try this:
Sum({$<site.VerifiedDate={">=$(=ReferenceDate)"},site.AddedDate={"<=$(=ReferenceDate)"}>}site.Counter)
That worked!
Thanks as always! You're the S-A KING!
S-A Queen?? What's that??
Set Analysis of course
S-A King you mean....
My sincere apologies. King it is! (very small picture). I'll update the post accordingly.
Begging forgiveness!!
Thanks again for the help.
no worries