Ordering Dates

[#1]

Hi All,

I have a month field. Jan - feb -mar etc. However in the list box the dates will not load in month order for some strange reason. Can i use the expression option in the Sort tab of the Properties and if so what do you write in there???

Thanks

Laura

[CELAMBARASAN]

Hi,

     Try creating a separating one more field

     Load * inline

     [Month,MonthNum

     jan,1

     Feb,2

     .

     .

     .

     .];

Use Monthnum as Sort by expression.

How you have created the monthField?

Celambarasan

[#3]

It is a field which is from the calendar. i want it to say jan, feb, march. i was wondering if i could use the dual function to solve my problem

[CELAMBARASAN]

Hi,

     Ya you can use Dual function.

Load Dual(Month,MonthNum) as MonthFieldName inline

     [Month,MonthNum

     jan,1

     Feb,2

     .

     .

     .

     .];

Did you created the month Field using Month() function?

Celambarasan

[jagan]

Hi,

Can you attach the sample file.

Regards,

Jagan.

[#6]

Can i put that in the sort expression?

[CELAMBARASAN]

Hi,

     This should be used inside the script only.

     If you have to do it in sort expression use the below expr

     =WildMatch(FieldName,'Jan','Feb','Mar','Apr','May'......)

Celambarasan

[#8]

That worked, but say the user clicks march as a selection nothing stays in its orginal order.

Any ideas?

[CELAMBARASAN]

Hi,

     Have you unchecked the Sort by State option?

Celambarasan