Rolling twelve month keyword field

This is the keyword formula for a field that lets the user select a month and year starting with the current month

and going forward 12 months. For example in June 2001, the user should be able to select from:

June 2001
July 2001
...
April 2002
May 2002

_monthlist := "January" : "February" : "March" : "April" : "May" : "June" : "July" : "August" : "September" : "October" : "November" : "December";

_thisyear := @Year(@Today); _list := (_monthlist + " " + @Text(_thisyear)) : (_monthlist + " " + @Text(_thisyear+1));

@Subset(@Subset(_list; @Month(@Today) + 11); -12)

This was first published in May 2001

Dig deeper on Domino Resources - Part 6

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchWinIT

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchVirtualDataCentre.co.UK

Close