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

Posted on 2012-09-13
Last Modified: 2013-12-18
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.



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.
Question by:Unifrax
    LVL 10

    Expert Comment

    Shouldn't process the field, but adjust the display of the field:
    For the year column, set the display as follows:
    Year only display of dateFor proper categorization, set formula of the column as @Date(@Year(fld_compdate); 1; 1)

    For the month column set the display as follows:
    Month only display of dateThe formula of the column should be @Date(@Year(fld_compdate); @Month(fld_compdate); 1)

    Author Comment

    This doesn't completely work.
    For every day there is a month and year entry.
    LVL 10

    Accepted Solution

    Just tested it with column formula =@Date(@Year(@Created); 1; 1) and 2nd column @Date(@Year(@Created);@Month(@Created);1)

    works as designed. Got your output if I just put in @Created in both columns.

    Note: The advantage of using this method is that although the month names are displayed as text, the sort order is in date order.  Since the sort and categorize utilize the underlying date value, you must process the date to get the desired categorization.
    So your column one formula should be @Date(@Year(fld_compdate); 1; 1) (which will generate 1 different value per year)
    Your column two formula should be @Date(@Year(fld_compdate); @Month(fld_compdate); 1) (which will generate 1 different value per month)

    The only othe reason of the categoriztion not working properly is that these two columns are not the first two columns, and another sort order prevails and throws the desired result off.

    Please report results.

    Author Comment

    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 ?
    LVL 10

    Expert Comment

    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")

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
    This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now