Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like
= MonthEnd(AddMonths(YourDateField, -1))
what is the variable value?
use this in variable
monthend(Datefield, -1) |
I already have variable value
=MaxString({<TRADE_DATE={"<$(=Date(vTradeFrom))"}>}DATE)
=MaxString({<TRADE_DATE={"<$(=Date(vTradeFrom))"}>}DATE)
what is the result you are getting for your variable?
Where in your variable you want this last day of the previous month?
Try this hope so it will help you
vmindate=Date(min(TRADE_DATE))
vmaxdate=Monthend(Date(Max(TRADE_DATE)),-1)
Set Analysis :
=maxstring({<TRADE_DATE={">=$(vmindate)<=$(vmaxdate)"}>}DATE)
Try
MonthEnd(Max({<TRADE_DATE={"<$(=Date(vTradeFrom))"}>}DATE),-1)
am able to find out the last workin day of previous month but the logic which m trying is not working