ListBox

[vanderson009]

Hi guys,

I have 12 Month of Data, I have list box which shows 12 Month.

but i want only show lates 6 month, for that what expression should i use.

- Thanks in advance,

Villyee

[its_anandrjs]

The last 6 months expressions is

In load script

Ex:-

Load

tempdate,

IF(YourDateField> AddMonths(MonthStart(Today()),-5), Month) as Last6Months

From Location;

Or in front end write in any list box

IF(YourDateField > AddMonths(MonthStart(Today()),-5), Month)

[VishalWaghole · Accepted solution]

Try this,

=IF(Date > AddMonths(MonthStart(Today()),-6), Month)