Data filter based on years

[krishna20]

Hi friends ,

I'm having car models no like 01,02,03,04,05,06,07,08,09,10.......................

I need to filter the car models which are belongs to current year. i.e ; cars manufactured in 2014.

Having Fields as Veh_Model and Veh_Model_Year

Please anyone can help me how to resolve this issue.

Regards

Krishna

[ashfaq_haseeb]

This is simply straight forward solution.

If you select year, it will show all the cars belong to that particular year.

If not then come-up with some sample data.

Regards

ASHFAQ

[krishna20]

Hi Ashfaq ,

I Agree with you. But i need to show filtered data directly in list box.

using Expression in List Box.

[ashfaq_haseeb]

Hi,

Have a look at attached application.

Regards

ASHFAQ

[krishna20]

Hi Ashfaq,

Thank you for your quick response. I'm Having model years from 1979 to future years. I need to show data for current and last two years. How it will be possible.

Regards

Krishna

[ashfaq_haseeb]

Like this.

Regards

ASHFAQ

[krishna20]

Hi Ashfaq ,

Thank you for your Response.you are right as per my requirement . Data i'm having is wrong.The max year i'm having 2088.Its not possible to do it as per my knowledge.

Regards

Krishna

[ashfaq_haseeb · Accepted solution]

Hi,

Its possible, we are not using max(year) instead we are using.

=if(Veh_Model_Year=year(today()),Veh_Model)

I don't think there is any issue.

Regards

ASHFAQ

[krishna20]

Hi Ashfaq,

I tried the above expression before.But filtering the data is not working properly.

Regards

Krishna

[ashfaq_haseeb]

Can you share your sample application.

Regards

ASHFAQ