Hi, I have a situation where the years are not in 'continuity'. For example, in the input data: '1-Jan-1994', '31-Jul-1996', '14-Sep-1999'...etc. It shows that data for a few years are missing.
I need to create a listbox which spans from minimum year to the maximum with all those years that falls in between...for example, I need the output in the list box as: 1994..1995..1996...1997...1998...1999 (though there is no data for 1995, 1997 and 1998)
I have taken min and max of the year in the expression section of the list box...but I am not able to proceed further.