Converting text field to number

[#1]

Hi

I have two fields which I would like to concatenate and convert to number so that I can easily sort the field

Script:

Load WeeksDate&''&WeekMonth as WeekDateMonth

From TableName

How can I do this?

[Colin-Albert]

The answer depends on the text format of WeeksDate and WeekMonth.

Can you post some example data?

[Anonymous]

Hello,

Use dual function, let the second parameter be a number so that u can sort on number. Like a rowno() for example

HTH

[#4]

WeekDates contains dates from the start of the wee to the end e.g 01-07 then months contains the month of the current selected week

Listbox will look like this

02-08 Mar

05-11 Jan

19-25 Jan...etc

I want to sot the list box to have months in a cronological order