Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
The answer depends on the text format of WeeksDate and WeekMonth.
Can you post some example data?
Hello,
Use dual function, let the second parameter be a number so that u can sort on number. Like a rowno() for example
HTH
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