Below are different formulae using which you can change the format of dates in MOSS 2007. This may be useful while displaying the birthdays of users etc.
To display Date as 01-23
=TEXT(Birthday,"mm-dd")
To display Month words as Jan
=CHOOSE(MONTH(Birthday),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")
To display Date as Jan 23
=TEXT(Birthday,"mmm dd")
To display Date January 23
=TEXT(Birthday,"mmmm dd")
Friday, March 19, 2010
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment