InfoPath Dev

Hi, I'm looking for a way to display repeating table with Year on column that must show range of year for 2016-2019. I tried use formulas as it look like only accept return one value, can it possible to show more than year value?

Do you mean that the value in the column should look like "2016-2019" or that the value should be anything from 2016 up to and including 2019? Or something else that I'm not understanding? :-)

Hi Hilary, sorry for not making it clear. Ok here the repeating table for example when I run like eg See image link https://i.ibb.co/dB6GsJg/wefwef.png I hope it clear?

Got it - you want to set a filter on the repeating table to only display items where the year is between those values. So - add a conditional formatting rule to your repeating table with the condition that the Year column is greater than or equal to 2016 AND that the Year column is less than or equal to 2019. :-)

That right. How do i make conditional formatting rule? if you can guide me to step by step? like formula something?

See attached. Save the file locally, right click and select design. Then preview. There is one table with a bunch of years filled out and the same table below with conditional formatting rules on it.

You are a star!!!!!