Date field help

[#1]

I have a field called Expense Year - Month.

Expense Year - Month

12/13/1987

11/24/1987

1/3/2016

2/5/2016

1/6/2017

2/6/2017

2/6/2018

3/6/2018

I only want to display

1/3/2016

2/5/2016

1/6/2017

2/6/2017

basically 12 months from current month.How can I do this ?

Thanks bunch.

[jagan]

Hi,

Try like this in set analysis

=Sum({<YearMonth = {'>=$(=MonthStart(Today()))<=$(=MonthEnd(Today(), 11))'}>} MeasureName)

Regards,

jagan.

[#3]

IF([Expense Month-Year] >= MonthStart(Today()) ,

IF([Expense Month-Year] <= MonthEnd(Today()) + 12,[Expense Month-Year]))

I have this as expression in my list box and its not displaying proper year.

[jagan · Accepted solution]

HI,

Try like this

IF([Expense Month-Year] >= MonthStart(Today()) ,

AND [Expense Month-Year] <= MonthEnd(Today(), 12) ,[Expense Month-Year])

Hope this helps you.

Regards,

jagan.

[#5]

Awesome.That worked..Thank you.