Report Cycle Formula?

HCL Domino Domino Forum
1

I’m stumped - our Report Cycle 1 = 1 Jun - 30 Nov and Report Cycle 2 = 1 Dec - 31 May, I am trying to determine in to which cycle a report falls based on the date of the report. This sounds too easy but…I have taken the RptDate date field and converted it to dd/mm, but having trouble with the report cycle dates since there is no year involved.

2

Subject: Report Cycle Formula??

Use @Month to extract the month from the report date, then figure out the cycle from there. This is one way of doing it:

the_mo := @Month(RptDate);

@If(the_mo = 6:7:8:9:10:11; “Cycle 1”; “Cycle 2”)

3

Subject: RE: Report Cycle Formula??

Thanks - that worked. Much better than the stuff I was thinking about.

4

Subject: Report Cycle Formula??

_t := @Month(datefield);_t < 6 | _t = 12