cancel
Showing results for 
Search instead for 
Did you mean: 

Display of data for current month along with all month end in column

former_member279151
Discoverer
0 Kudos

Hi Folks,

I need to display data for all month end along with current date data in a single column

OCT-31-2016
NOV-30-2016
DEC-31-2016
JAN-27-2017 (considering data available for current day date)

I was able to display for month end using lastdayofmonth function but this will not allow me to display for current month JAN-27-2017 which will display as JAN-31-2017

Accepted Solutions (0)

Answers (1)

Answers (1)

amitrathi239
Active Contributor
0 Kudos

use this.

=If(MonthNumberOfYear([Date])=MonthNumberOfYear(CurrentDate())) Then CurrentDate() Else LastDayOfMonth([Date])