View problem

In a view in one column we write formula

@Trim(@Right(Month;4)) + “-” + @Left(Month;3)

this code was display 2005-jan,2005-march like this

and make this column descending,standard.This show in view decending order in year wise but i want to so month in like jan, feb, march this way----,how it possible

user enter in filed Mar-2004,april-2004,jun-2005 in this way .I am able to categorised year wise but not month wise like jan,feb,march----

how it possible pls help me

amar

Subject: view problem

hope this will help u to fetch the month

@Select(@Month(month);“January”;“February”;“March”;“April”;“May”;

“June”;“July”;“August”;“September”;“October”;“November”;“December”);

regard’s

sonu joshi

Subject: RE: view problem

You’re trying to sort a string in date order rather than in alphabetical order. You can’t sort a string in date order. You need a date value that you can sort.

You can calculate a date based on the contents of this string, but this is inefficient to do in a view formula. If you already have a date field on the form you could use that for your sorting. If you can’t get the date to display in a column the way you want, you can hide the date column. But by using the formatting tab of the column properties, you can get the date to appear pretty much any way you want.