Hi, <o:p></o:p>
I was
wondering if I could get some advice on how to get a date to always fall on a
Sunday. I am utilising the code below which works to the extent that it is
adding the 2 years as needed however I need it to always fall on the Sunday
after. A user should always enter a Mondays date into the
kf_tenancyconversiondate this then looks at the tenancy type and if this says 2
years then should add 2 years to the kf_tenancyconversiondate date and enter
the next Sundays date. Any advice on how this works will really be helpful.<o:p></o:p>
Thank you
in advance<o:p></o:p>
Kind
Regards<o:p></o:p>
Kully
var CRM_FORM_TYPE_CREATE = "1";
var DUE;
var i = 0;
var days_to_add = 730;
var ttype = crmForm.all.kf_tenancytype.DataValue;
if (ttype == 1)
{
{
DUE = new Date(crmForm.all.kf_tenancyconversiondate.DataValue.getTime() + (days_to_add*24*60*60*1000));
//0 = Sunday, 6 = Saturday, if the date not equals a weekend day then increase by 1
if (DUE.getDay() != 0 && DUE.getDay() != 6)
{
i+=1;
}
days_to_add += 1;
}
DUE = new Date(crmForm.all.kf_tenancyconversiondate.DataValue.getTime() + (days_to_add));
crmForm.all.kf_enddatefixedtermtenancy.DataValue = DUE;
}