Explode data range problem

HCL Domino Domino Forum
1

I have an application with two date fields: PlannedStartDate and PlannedEndDate.

I am trying to find all the dates in between using the explode function. I tried a few combination of this and all gave errors:

v1:=@Text(PlannedStartDate;“D0S0”);

v2:=@Text(PlannedEndDate;“D0S0”);

@Explode(v1-v2)

v1:=PlannedStartDate

v2:=PlannedEndDate

@Explode(v1-v2)

Any ideas on how I could make this work?

Thanks in advance

2

Subject: Try @Eval

Something like this:

@Explode(@Eval(“[” + v1 + “-” + v2 + “]”));

3

Subject: Solved

Thank your for the response. I didnt get a chance to try your solution but I got it to work usingthe following code.

v1:=@Text(@Year(PlannedStartDate)) + ", " + @Text(@Month(PlannedStartDate)) + ", " + @Text(@Day(PlannedStartDate));

v2:=@Text(@Year(PlannedEndDate)) + ", " + @Text(@Month(PlannedEndDate)) + ", " + @Text(@Day(PlannedEndDate));

v:=@TextToTime(v1+“-”+v2);

@Explode(v)