How to calculate last month of maximum day

[panipat1990]

Dear Team,

Kindly help me for resolving this problem.How to calculate last month's Maximum day.

[sunny_talwar]

Not sure what your variable vMaxDate is, but assuming it is Date(Max(Link_Date)), try this:

May be this:

=Sum({$<Link_Date={"$(=Date(Max({<Link_Date = {'<$(=MonthStart(Max(Link_Date)))'}>} Link_Date)))"}>} Sale)

the inner set analysis is just saying that find the max ignoring the max month

[panipat1990]

Dear Sunny,

i stuck a requirement. i have data oct, nov dec month of different dates.

in oct month i have 24/10/2016,25/10/2016,26/10/2016,27/10/2016,28/10/2016

In Nov Month i have 26/11/2016,27/11/2016,28/11/2016,29/11/2016,30/11/2016

In Dec Month i have 11/12/2016,12/12/2016,13/12/2016,14/12/2016,15/12/2016,16/12/2016

For this i am sharing a qvd where all data exit with date.

i want to show only each month of maximum date wise Avl Value.If i see in oct month then it show only 28/10/2016 date regarding value

If i see in Nov month then it show 30/11/2016 date regarding value

If i see in Decmonth then it show 16/12/2016  date regarding value

How is it.Kindly Help Me For soliving this issue. Maximum date of each month

[sunny_talwar]

I don't see any qvd or qvw attached?

[panipat1990]

Kindly tell me how to write Max date of previous month if my last month's max date is 25/12/2016.and 24/11/2016

Not monthend