How to sort the numeric value Of List box.

[Anonymous]

Hi Community,

I have date field in below format and i have to sort this value in List box in ascending order.

e.g.

Date

2016-12,

2016-1,

2016-10,

2016-5

Expected Output

2016-1,

2016-5,

2016-10,

2016-12

Please also refer below image

Thanks in advance.

[sunny_talwar]

Dual function assigns a numeric and text value to a field. For text, we are using what you wanted to see and for numeric we used WeekStart() function which basically helps you sort the text value best of the underlying numeric value.

[Anonymous]

Thanks Sunny,

Now i understood.