Link to home
Start Free TrialLog in
Avatar of Unifrax
UnifraxFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Change Number to Month in Lotus Notes (1 = Jan, 2 = Feb etc.)

Withing my form there's a field (fld_compdate) that is set to a date when a document is complete (button pressed).

I am attempting to setup a view that will display by year then month.

Example.

2012
        Jan
              doc1
              doc2
        feb
               doc1

I have setup the 1st collum to @year(fld_compdate) categorized.
2nd Collum @month(fld_compdate) but this returns a number not a month in text format.
Avatar of larsberntrop
larsberntrop
Flag of Netherlands image
Shouldn't process the field, but adjust the display of the field:
For the year column, set the display as follows:
User generated imageFor proper categorization, set formula of the column as @Date(@Year(fld_compdate); 1; 1)

For the month column set the display as follows:
User generated imageThe formula of the column should be @Date(@Year(fld_compdate); @Month(fld_compdate); 1)
Avatar of Unifrax
Unifrax
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

This doesn't completely work.
For every day there is a month and year entry.
view.JPG
ASKER CERTIFIED SOLUTION
Avatar of larsberntrop
larsberntrop
Flag of Netherlands image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Unifrax
Unifrax
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Great that works perfectly!

I have created a third collum which shows the day.
Any ideas on how I could set it to display 1st 2nd 3rd instead of 1 2 3 ?
Avatar of larsberntrop
larsberntrop
Flag of Netherlands image
Unless its an available format option (check the column formatting dialogbox), need a fo
Like d:=@Day(fld_compdate);@Text(d)+@If(d = 1; "st"; d = 2; "nd"; d = 3; "rd"; "th")