Hi KennyChan6996,
Apply the below javascript on OnChange of the Timeline field.
function new_timelineOnchange() {
var This_Month = "This Month";
var This_Quarter = "This Quarter";
var Next_Quarter = "Next Quarter";
var This_Year = "This Year";
var Next_Year = "Next Year";
var currentdate = new Date();
var currentmonth = currentdate.getMonth();
var currentyear = currentdate.getFullYear();
var estclosedate;
// Get OPtion set text
var timeline = Xrm.Page.data.entity.attributes.get("new_timeline");
var timelineValue = timeline.getSelectedOption().text;
if (timelineValue != null) {
// apply to loop for each option
switch (timelineValue) {
case This_Month:
// define the logic and set the appropriate date in datetime field based on todays date
estclosedate = new Date((new Date(currentyear, currentmonth + 1, 1)) - 86400000);
break;
case This_Quarter:
// define the logic and set the appropriate date in datetime field based on todays date
if (currentmonth < 3) {
estclosedate = new Date((new Date(currentyear, 3, 1)) - 86400000);
break;
}
if (currentmonth < 6) {
estclosedate = new Date((new Date(currentyear, 6, 1)) - 86400000);
break;
}
if (currentmonth < 9) {
estclosedate = new Date((new Date(currentyear, 9, 1)) - 86400000);
break;
}
if (currentmonth < 12) {
estclosedate = new Date((new Date(currentyear, 12, 1)) - 86400000);
break;
}
case Next_Quarter:
// define the logic and set the appropriate date in datetime field based on todays date
// define the logic and set the appropriate date in datetime field based on todays date
if (currentmonth < 3) {
estclosedate = new Date((new Date(currentyear, 6, 1)) - 86400000);
break;
}
if (currentmonth < 6) {
estclosedate = new Date((new Date(currentyear, 9, 1)) - 86400000);
break;
}
if (currentmonth < 9) {
estclosedate = new Date((new Date(currentyear, 12, 1)) - 86400000);
break;
}
if (currentmonth < 12) {
estclosedate = new Date((new Date(currentyear, 15, 1)) - 86400000);
break;
}
break;
case This_Year:
// define the logic and set the appropriate date in datetime field based on todays date
estclosedate = new Date(currentyear, 11, 31);
break;
case Next_Year:
// define the logic and set the appropriate date in datetime field based on todays date
estclosedate = new Date(currentyear+1, 11, 31);
break;
}
Xrm.Page.data.entity.attributes.get("new_estclosedate").setValue(estclosedate);
// force submit the date field, other wise field will appear is null
Xrm.Page.data.entity.attributes.get("new_estclosedate").setSubmitMode("always");
}
}
Techsun
MSN:caims#techsun.com
If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"
MSCRM Can i set this base on current date and field By using Javascript???
