< Back
Document Subject: @Explode date range in Xpages
Hint Short Cut: Add this to your code & documentation to help you find this page.
http://#ExplodeDatesXpages or http://A555F9/nn.nsf/ByAlias/ExplodeDatesXpages

@Explode date range doesn't work in xpages.




To fix this here is a bit of javascript.

 

var Start_Date = getComponent("Start_Date").getValue();
var End_Date = getComponent("End_Date").getValue();

// Only update if End Date is not nothing, assume Start_Date is set to today
if (@Text(End_Date)!="")
{
 
dDatebetween=new Date(Start_Date.getTime());
var dts="";

while (dDatebetween.getTime() <= End_Date.getTime())
 {

   dts=dts+(@Right("0"+@Text(@Day(dDatebetween)),2)+"/"+@Right("0"+@Text(@Month(dDatebetween)),2)+"/"+@Right(@Text(@Year(dDatebetween)),2))+",";

   dDatebetween=new Date(dDatebetween.getTime()+86400000)
 }

getComponent("HolDates").setValue(@Left(dts,@Length(dts)-1));

}