web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Auto-populate text fie...

Microsoft Dynamics CRM (Archived)

Auto-populate text fields based on a date field

(0) Share

Report

Report

Posted on by Community Member

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

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Saroj Das 3,355 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Royal King 27,686 on at

Like (0)

Report

function FormatDate(fieldname) {

    var d = Xrm.Page.data.entity.attributes.get(fieldname).getValue();

    if (d != null) {

var months = ['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'];

        var  date = d.getDate();

        var curr_month = d.getMonth();

        var year = d.getFullYear();

var month= months[curr_month] ;

    }

    else return null;

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Guido!

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

SA-08121319-0 4

#1

Calum MacFarlane 4

#3

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans