Showing the Date Months in a View Column as Their Spelled-out Months

Author: Tripp W Black

Created: 11/16/1999 at 11:47 AM

 

Category:
Notes Developer Tips
Formulas, Views

@Word("January,February,March,April,May,June,July,August,September,October,November,December"; ","; (@Month(Date)))
Date being your date field on the form


Sorted columns method:

You need 3 columns.

1st column - no title, hidden, width of 3, standard descending sort order, with this formula: @Year(@Created)

2nd column - no title, hidden, width of 3, show responses only, standard ascending sort order, with this formula: @Month(@Created)

3rd column - no title, width of 1, show twistie if row is expandable, categorized ascending sort order, use this formula:
@Select(@Month(@Created);
"January";"February";"March";"April";"May";"June";"July";"August";"September";"October";"November";"December")

....

+ " " + @Text(@Year(@Created))

previous page