developerWorks

Lotus SmartSuite Forum

RE: 123r5w Date Problem

RE: 123r5w Date Problem
Posted by Russ Bartoli on 5.Dec.09 at 03:52 PM using a Web browser
Category: 1-2-3

Release: All Releases

Platform: All Platforms

The most elegant way to do this:

@MONTH(1+@MOD(@MONTH(A1),12))

This avoids the duplicate expressions that @IF requires.

123r5w Date Problem (Rick Parker 4.Dec.09)

. . RE: 123r5w Date Problem (Frank E Spoerl 4.Dec.09)

. . . . RE: 123r5w Date Problem (Russ Bartoli 5.Dec.09)

. . . . . . RE: 123r5w Date Problem (Rick Parker 5.Dec.09)

. . . . . . . . An even easier way (Russ Bartoli 6.Dec.09)

. . . . . . . . . . RE: An even easier way (Rick Parker 9.Dec.09)

Document Options

Document options

RSS feeds

	IBM Support Portal - Lotus software
	Lotus Support documents
	Lotus support by product
	Lotus support downloads
	Lotus support RSS feeds

	IBM Composite Applications
	IBM Mashup Center
	IBM Connections
	IBM Docs
	IBM Forms
	IBM Mobile Connect
	IBM Sametime
	IBM SmartCloud for Social Business
	IBM Web Experience Factory
	Lotus Domino
	Lotus Domino Designer
	Lotus Expeditor
	Lotus Foundations
	Lotus iNotes
	Lotus Instructor Community Courseware
	Lotus Notes
	Lotus Notes & Domino Application Development
	Lotus Notes Traveler
	Lotus Protector
	Lotus Quickr
	Lotus Symphony
	IBM Web Content Manager
	WebSphere Portal

	Notes/Domino 9.0
	Notes/Domino 8.5 + Traveler
	Notes/Domino XPages development forum
	Notes/Domino 8
	Notes/Domino 6 and 7
	Notes/Domino 4 and 5
	IBM Connections
	IBM Forms
	IBM Mobile Connect
	IBM Sametime
	IBM SmartCloud Notes
	IBM SmartCloud Meetings
	IBM Web Content Manager
	Lotus Domino Document Manager
	Lotus e-learning
	Lotus Enterprise Integration
	Lotus Expeditor
	Lotus Protector
	Lotus Quickr
	Lotus SmartSuite
	Lotus Symphony
	Lotus Symphony Developer Toolkit Support
	Lotus Workflow