Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using this set expression...
[FirstDate Date]=,[FirstDate Day]=,[FirstDate Weekday]=,[FirstDate Year]=,[FirstDate Month]=,[FirstDate Quarter]=,[FirstDate _MonthSerial]=,[FirstDate _QuarterSerial]=,[FirstDate _WeekSerial]=,[FirstDate Year-Month]=,
[FirstDate Date] = {"<=$(=AddYears(Max([FirstDate Date]), -1))"},
[FirstDate Date] = {">=$(=AddYears(Min([FirstDate Date]), -1))"}
It's supposed to give me records related to the currently selected date range minus 1 year. But it is bringing back the whole year. I need the equivalent of a logical AND...
Any ideas?
Thank you
You can try this
[FirstDate Date]=,
[FirstDate Day]=,
[FirstDate Weekday]=,
[FirstDate Year]=,
[FirstDate Month]=,
[FirstDate Quarter]=,
[FirstDate _MonthSerial]=,
[FirstDate _QuarterSerial]=,
[FirstDate _WeekSerial]=,
[FirstDate Year-Month]=,
[FirstDate Date] = {">=$(=AddYears(Min([FirstDate Date]), -1))<=$(=AddYears(Max([FirstDate Date]), -1))"}
E.g. combine those expression in 1 field...
You can try this
[FirstDate Date]=,
[FirstDate Day]=,
[FirstDate Weekday]=,
[FirstDate Year]=,
[FirstDate Month]=,
[FirstDate Quarter]=,
[FirstDate _MonthSerial]=,
[FirstDate _QuarterSerial]=,
[FirstDate _WeekSerial]=,
[FirstDate Year-Month]=,
[FirstDate Date] = {">=$(=AddYears(Min([FirstDate Date]), -1))<=$(=AddYears(Max([FirstDate Date]), -1))"}
E.g. combine those expression in 1 field...
Perfect, thanks!
You're welcome. Happy Qliking!