Notes Ninjas Notes Ninjas
Lotus Notes hints, tips, error messages
@Explode date range in Xpages

Hint Short Cut: Add this to your code & documentation to help you find this page.
http://www.notesninjas.com/#ExplodeDatesXpages or http://www.notesninjas.com/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));

}

 

 

 Jump to:     Notes Tips
    Lotus Notes Index 
  Register for Tips
Previous Lotus Notes Tip 
    Next Lotus Notes Tip
Your company logo here?
Adam Foster
Free Cash Making Web Site
Free Revenue Earning Blog Site
 Free Revenue Earning Newsletter Site   
Free Search Pages Free Web stats
Free Contact Us page
Cheap .com domain names
 Need a website or 
   Lotus Notes
  problem solved?
Adam Foster
Lotus Notes 5 All-in-one Certification Exam Guide by Libby Schwarz, Ben Malekzadeh
Sort out your CLP with this book.
See at: Amazon.co.uk | Amazon.com |