Drop Down Control - Need to default to max date

[Peter Finseth 2]

How do you create a drop down list property control to default to the most recent month in the column The column essentially has every month end for 2 years. Need the drop down to automatically use the most recent date, but then have the other dates in descending order after it. Thanks!

[Sushank Goel]

Create calculated column :Month(Max([datecolumn]))

Now create a Integer document property control and select "Unique values in column" and select the created column.

[John Justus 2]

If you see the sushank screenshot, there is an scripting functionality for that property. You can achieve whatever your requirement might be using the scripting functionality.

[Peter Finseth 2]

Correct. Want the default date to populate as Max Date but then have all other dates in descending order from there. So as of today, July 2017, it would default to most recent month end 6/30/17 then 5/31/17, 4/30/17, 3/31/17, and so on.

[adam bronze]

susshank...it seems that will show max month as the default...but i believe pdfinseth's requirement is to have  the drop down show the other months too. i ask because i have the same requirement. e.g., the visualization opens up to the current/max month on the drop down, but the user should have the options to choose earlier months. 

 

thanks

[Giovanni De Ciantis]

I've managed to do something similar creating a new information link to output the dates in a new data table. Then added the dropdown list property control using the new column of dates from the previous IL.