Generate a list of date

HCL Domino Domino Forum
1

Hello,

I need help for create a list of date in a form. I have a begin date, end date, and a day (for example : Monday).

My User select the monday, the begin date is 15/03/05, my end date 15/05/05. I want generate a list of all monday between the 15/03/05 and the 15/05/05. In formula language it’s possible!! :wink:

Thanks a lot for your help!

@++

2

Subject: Generate a list of date

a:= @Explode(@TextToTime(@Text(@Date(@Today)) + “-” + @Text(@Adjust(@Date(@Today);0;3;0;0;0;0))) );@For(n :=1; n<=@Elements(a); n:= n + 1;

b := @If(@Weekday(@texttotime(a[n]))=2;@trim(b : a[n]);b));

@Prompt([OkCancelList];“Display Mondays”;“Mondays”;“”;b)

Check out help for @Explode… see the example…

3

Subject: Generate a list of date

This samples will give you light in this matter:

This example returns 07/02/96; 07/03/96; 07/04/96; 07/05/96.

@Explode([07/02/96 - 07/05/96])

This example returns 07/01/94; 05/01/94; 10/01/94; 10/02/94; 10/03/94; 04/01/94; 04/02/94; 04/03/94.

Note the order in which the dates are returned: single date-time values are returned first, followed by exploded date-time ranges. The return value is a text list.

@Explode([07/01/94]:[10/01/94 - 10/03/94]:[05/01/94]:[04/01/94 - 04/03/94])

4

Subject: RE: Generate a list of date

Hello, thanks for your response.

I don’t understand a thing. When I try this example the value is all the date between the two dates. For example with @Explode([07/02/96 - 07/05/96]), the result is 07/02/96 08/02/96 09/02/96 10/02/96 until 07/05/96.

It’s normal??

Thanks,

regards

5

Subject: He coded it with international format mm/dd/yyyy.