How to get the repeat dates between two dates?

HCL Domino Domino Forum
1

Good afternoon, I have a problem with getting the repeat dates. for example,

in a form, there are three fields: startDate, endDate, and repeatDate. if I enter the 12/14/2006->startDate, 12/16/2006->endDate, I would like to get 12/14/2006, 12/15/2006, 12/16/2006 on the repeatDate field, how to use fomula to get it?

Thanks,

inda

2

Subject: How to get the repeat dates between two dates?

You need to use a Date Range. Trouble is, there is no documentation I can find that tells you how! The help file contains no info on creating date ranges except by using literals. But this is the way I do it:

DATE1 :=[1/12/06];

DATE2 := [31/12/06];

DATERANGETXT := “[” + @text(DATE1) + “-” + @Text(DATE2) + “]”;

@Explode(@TextToTime(DATERANGETXT));

This will return a multi-value date list with all the dates between and including date1 and date2

Cheers

Simon

3

Subject: RE: How to get the repeat dates between two dates?

That is really helpful!

Many thanks for Paul and Simon!!

Linda

4

Subject: How to get the repeat dates between two dates?

Will produce 12/14/2006, 12/15/2006, 12/16/2006 in a multi value date field

DateRange := “12/14/2006 - 12/16/2006”;

@Explode(@TextToTime(DateRange))

so you could write this for your RepeatDate field formula:

DateRange := @Text(StartDate) + " - " + @Text(EndDate);

@Explode(@TextToTime(DateRange))