DATERANGETXT & biweekly?
Posted by linda sun on 20.Jul.12 at 10:40 AM using a Web browser Category : Domino Designer Release: 7.0.3 Platform: Windows 2000
Hi everyone,
I have a problem which is how to get biweekly dates from the formula below?
for example:
DATE1 :=[1/07/2012];
DATE2 := [31/07/2012];
DATERANGETXT := "[" + @text(DATE1) + "-" + @Text(DATE2) + "]";
@Explode(@TextToTime(DATERANGETXT));
I can get the dates all in July, but I only want to have biweekly(only Mondays or Wed), they should be
Mon: 01/07/2012, 16/07/2012,30/07/2012
Wed: 04/07/2012,18/07/2012,25/07/2012
how to put the condition to the formula?
Thank you very much!
Linda
DATERANGETXT & biweekly? (linda sun 20.Jul.12)
. . RE: DATERANGETXT & biweekly? (Konrad Hoszwa 23.Jul.12)
. . . . RE: DATERANGETXT & biweekly? (linda sun 23.Jul.12)
. . RE: DATERANGETXT & biweekly? (Phil M Jones 23.Jul.12)
. . . . RE: DATERANGETXT & biweekly? (linda sun 23.Jul.12)
. . . . . . RE: DATERANGETXT & biweekly? (Phil M Jones 24.Jul.12)
. . . . . . . . RE: DATERANGETXT & biweekly? (linda sun 24.Jul.12)