How to show previous month last day value

[Karim_Khan]

Hi Team,

   I have tried the approach but not able to show only those values in current month 

which are not purchased on the last working day of previous month

and rest of the value of current month also should got exclude

I have tried belwo expression also

=IF(DATE<>'$(vPrevMonthLast)' AND Pur_Cd='Purchase',Only({$<DATE={">=$(vFromDate)<=$(vToDate)"}>} ID))

but above expression is taking current month ID also which i do not want

vPrevMonthLast=Need to take last working day of previous month'

PFA

Regards,

KK

[Karim_Khan]

am able to find out the last workin day of previous month but the logic which m trying is not working

[sasiparupudi1]

When you say logic is not working what exactly is the problem?

wht is the variable value vTradeFrom

[Karim_Khan]

its is nothing jst startdate of my DATE filed

[vishsaggi]

Can you share a sample you are working on? And also highlight the logic where you implementing this?