Hi Community,
On my Opportunity form I have a custom date field .
I also have 2 custom text fields called Month and Year.
How do I auto-populate the Month and Year fields with values based on the date field?
Example 1:
Date Field user selects 01/01/2014
Month auto-populates with 'January'
Year auto populates with '2014'
Example 2:
Date Field user selects 12/12/2015
Month auto-populates with 'December'
Year auto populates with '2015'
Cheers,
VVG
*This post is locked for comments
Thanks Guido!
Share
Report
All responses (
Answers (
27,686function FormatDate(fieldname) { var d = Xrm.Page.data.entity.attributes.get(fieldname).getValue(); if (d != null) { var date = d.getDate(); var curr_month = d.getMonth(); var year = d.getFullYear(); var month= months[curr_month] ; } else return null;}Hello, on dateField onchange event call the function. If required, modify as per your requirement.
function getMonthYear(){
var dateVal=Xrm.Page.getAttribute(dateField).getValue();
var months = ["jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec"];
if(dateVal!=null ){
var data=dateVal.split('/');
if(data.length>0){
// for example your date is in dd/mm/yyyy format
// 31/12/2013
var mth=months[data[1]-1];
var yr=data[2];
Xrm.Page.getAttribute('monthField').setValue(mth);
Xrm.Page.getAttribute('yearField').setValue(yr);
}
}
}
hth
Thanks,
Saroj
