Script to set dates for scheduled repoorts [message #686644] |
Wed, 22 June 2011 16:32 |
sjung Messages: 2 Registered: December 2010 |
Junior Member |
|
|
dFrequency = params["pintFrequency"].value;
dbegin = new Date();
dend = new Date();
switch (dFrequency) {
case 1: // Daily
params["pdtmBeginDate"].value = dbegin;
params["pdtmEndDate"].value = dend;
break;
case 2: // Monthly
dyear = dbegin.getFullYear();
dmonth = dbegin.getMonth();
params["pdtmBeginDate"].value = new Date(dyear,dmonth,1);
dd = new Date(dyear, dmonth + 1, 0);
params["pdtmEndDate"].value = dd;
break;
case 3: // Quarterly
dyearq = dbegin.getFullYear();
dmonthq = dbegin.getMonth();
switch (dmonthq){
case 0,1,2:
params["pdtmBeginDate"].value = new Date(dyearq,0,1);
params["pdtmEndDate"].value = new Date(dyearq,2,31);
break;
case 3,4,5:
params["pdtmBeginDate"].value = new Date(dyearq,3,1);
params["pdtmEndDate"].value = new Date(dyearq,5,30);
break;
case 6,7,8:
params["pdtmBeginDate"].value = new Date(dyearq,6,1);
params["pdtmEndDate"].value = new Date(dyearq,8,30);
break;
case 9,10,11:
params["pdtmBeginDate"].value = new Date(dyearq,9,1);
params["pdtmEndDate"].value = new Date(dyearq,11,31);
break;
}
}
|
|
|
Powered by
FUDForum. Page generated in 0.03193 seconds