Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have requirement i am using set as sum(final Amount) to show values for all month in a table.
But my requirement is in that table i should show values of each month last date.
Say if user selects march field it should display total values of 31st March end value not the whole month value and should be same for all months.
My date field is Date.
I tired with MonthEnd function but i am not getting the values.
Ya ok sorry i am trying in different methods with some dummy values.