Showing max date as per month

[deepakqlikview_123]

I have 2 days for each month that is last and second last i need to show last day for each date for respective month.

Please suggest

[#2]

Hi can you send your exel sheet.

[amit_saini]

Deepak,

Use:

Thanks,
AS

[#4]

Hi amit,

Deepak wants the last date.

[amit_saini]

Here it is:

Thanks,.
AS

[deepakqlikview_123]

Hi All,

I need to show month end data  MMM YYYY format can you please suggest how shall i go ahead.

Thanks

[amit_saini]

Deepak,

Either define this format at the back-end or from below:

Thanks,

AS

[PrashantSangle · Accepted solution]

Hi,

You can use MonthName()

or

date(fieldNAme,'MMM YYYY')

or

do as suggested by amit saini.

Regards