FORMULA LANGUAGE
Examples: @Month
1. This example returns 1.
@Month([1/15/88])
2. This example returns 1 and 2 in a list.
@Month([1/15/88] : [2/15/88])
3. This example returns 12 if it is December.
@Month(@Now)
4. This example returns 2 if it is any date in December other than the 30th or the 31st. If it is December 30th or 31st, returns 3.
@Month(@Adjust(@Now;2;2;2;2;2;2))
5. 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.
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
See Also
@Month
Glossary
Feedback on
Help
or
Product Usability
?
Help on Help
All Help Contents
Glossary