Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Hi,
Can you attach the sample file.
Regards,
Jagan.
Can i put that in the sort expression?
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
That worked, but say the user clicks march as a selection nothing stays in its orginal order.
Any ideas?
Hi,
Have you unchecked the Sort by State option?
Celambarasan