How to sort values in input box

[#1]

I am populating an inputbox with the values of a field using concat function and now I want to sort the values.

Any help is appreciated.

Thanks.

[Anonymous]

Raj,
Can you provide some more details? Concat function can use optional paramater for sort order, but I can't tell if it's relevant to your question.

[#3]

Michael,

I am populating 'YYYY-MM' values from year_month field in two inputboxes to be able to make comparison of facts between these two time periods. The problem is it a string field so it will not return numeric value when passed as a parameter for sort order in cancat function.

Is there any way to get around?

Thanks.

[Anonymous]

One possible way is to convert string to a date, like this before using for comarison:
makedate(left(PeriodStart,4), right(PeriodStart,2))
Another is to force user to enter in a date format (that ccould be YYYY-MM)

[Anonymous · Accepted solution]

Looks like the most reliable way is combination of both. Take a look, notice the properties of the variables.
I use expression that handles both YYYY-MM and YYYY-M situations.

[#6]

Thanks for all your help Mike !!