
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to show previous month last day value
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
- « Previous Replies
-
- 1
- 2
- Next Replies »


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try like
= MonthEnd(AddMonths(YourDateField, -1))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
what is the variable value?
use this in variable
monthend(Datefield, -1) |

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I already have variable value
=MaxString({<TRADE_DATE={"<$(=Date(vTradeFrom))"}>}DATE)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=MaxString({<TRADE_DATE={"<$(=Date(vTradeFrom))"}>}DATE)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
what is the result you are getting for your variable?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Where in your variable you want this last day of the previous month?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
MonthEnd(Max({<TRADE_DATE={"<$(=Date(vTradeFrom))"}>}DATE),-1)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
am able to find out the last workin day of previous month but the logic which m trying is not working

- « Previous Replies
-
- 1
- 2
- Next Replies »