Set Analysis unable to exclude common record

[Karim_Khan]

Hi Team,

   I wanted to compare two dates value and need to show only those records which are not present in previous month last day and

present in current month last day i.e i wanted to exclude all common record between these two dates and put only non-matching records.

I have tried the below expression

varibale define

for getting last day of current  month

vLastDayPrevMon=MonthEnd(AddMonths($(vFromDate), -1))

LastDayCurrMon=MonthEnd($(vToDate))

=if(Date='$(vLastDayPrevMon)' AND Date='$(vLastDayCurrMon)',ID)

stalwar1‌

[Karim_Khan]

This entire value

Count(DISTINCT {<DATE = {[$(=Date(Floor(MonthEnd(Max({<ID>}DATE), -1))))]}>} DATE) + Sum(0)

[sunny_talwar]

Counting DISTINCT Dates where Date = last date of the previous month.... and seems like adding Sum(0) to avoid nulls because of the set analysis on date....