Dynamic Default Date in Drop Down List - Latest Month

[max00d]

I am trying to create a way to get the default selection in a listbox to be the latest month.  As time goes on this obviously changes.  This seems like it should be easy but I just cant figure it out.  Can anyone help?  Thanks

[TejaSurapaneni]

Hello Max,

Is it List (Controls) or List table?

Thanks & Regards,

Teja Surapaneni

[max00d]

Hi

it's in a drop-down list control

Thaks

[TejaSurapaneni]

Hello,

I don't think so it is possible!!!!, Lets see some of our community members will give us solution.

Thanks & Regards,

Teja Surapaneni.

[RobNewZealand]

Hey guys, One example we have is do it on the data side so basically the dataset is amended each month.  We have a example of this... which works reasonabily well , however when you want to use the functionality of  difference between this period and last period I imagine its going to break.  This is something im trying to look into at the moment.  So sorry not really a answer but feeling your pain... Cheers Rob

[Explore_SAS]

Hey max,

I think its doable, can you try below option and let me know if it works for you.

First make your dropdown value an required field. ( Go to the properties tab and navigate to your dropdown control and check the Required check box )

That will make you mandatory to select the field in the dropdown. Then right click your dropdown go to the "sort frequency" option and change it to descending.

let me if it works for you.

Thanks

Amol

[TejaSurapaneni]

Hi,

There is a related discussion

Thanks & Regards,

Teja Surapaneni

[Fredrik_Hansson]

Do you mean this?

https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-set-default-date-value-for-a-report-using...