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.