Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)