Is there an easy way of showing dates with the alphabetical month names (not numbers)?

HCL Domino Domino Forum
1

Hello,Is there an easy way of showing dates with the alphabetical month names (not numbers)?

For example… 19 January 2007 (not 19/01/2007)

Thanks in advance.

2

Subject: Is there an easy way of showing dates with the alphabetical month names (not numbers)?

Print Format( Date, “d mmmm yyyy” )

3

Subject: Is there an easy way of showing dates with the alphabetical month names (not numbers)?

Bob,

Create a hidden column in front of the date, and there have the ‘real’ date. You then sort on that date.

John

4

Subject: Is there an easy way of showing dates with the alphabetical month names (not numbers)?

Look in the help for @Month.(mind due is this ‘easy’?!)

space:= " ";

comma:=“,”;

month:=@Select(@Month(dueDate);“January”;“February”;“March”;

“April”;“May”;“June”;“July”;“August”;“September”;“October”;

“November”;“December”);

day:=@Text(@Day(dueDate));

year:=@Text(@Year(dueDate));

month + space + day + comma + space + year

“This formula returns a formatted date string based on the contents of the dueDate field. For example, if dueDate contains “06/26/95” the formula returns June 26, 1995. If dueDate contains “01/24/96 3:40:43 P.M.,” the formula returns January 24, 1996.”

5

Subject: Is there an easy way of showing dates with the alphabetical month names (not numbers)?

Many thanks folks!