Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hi,
Try like this in set analysis
=Sum({<YearMonth = {'>=$(=MonthStart(Today()))<=$(=MonthEnd(Today(), 11))'}>} MeasureName)
Regards,
jagan.
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.
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.
Awesome.That worked..Thank you.