Microsoft Dynamics CRM (Archived)

need to populate the date field based upon year and month as global option set values using javascript

(0) Share

Report

Posted on by Nagaraj M

161

Hi team,

I am having two global option sets one is for year and one is for month.

based upon the selection i need to populate one date field with the last date of that particular selected month.

i.e if I select 2018 as year and march as month.

then my date field should be set as 31/3/2018 ( last date of that month).

kindly provide some links as i am new to use Date time fields in javascript

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Sort by

Suggested answer

Preeti Sharma 2,678 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please try to use common methods available with JavaScript for getting date from month.

I hope following links will be helpful to you:

[View:http://www.encodedna.com/javascript/first-and-last-day-of-a-given-month-in-javascript.htm]

[View:http://www.tutorials2learn.com/tutorials/scripts/javascript/get-last-date-of-the-month-javascript.html]

Just pass parameters selected from optionsets.

Thanks.

Was this reply helpful? Yes No
Suggested answer

Arpit Shrivastava 7,518 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hello Nagaraj,

Please try below code. Apologies in advance for having any syntax issue.

// Get Month and Year from Global Option Set Field
var getYear = Xrm.Page.getAttribute("<Year Option Set Field Schema Name>").getText();

var getMonth = Xrm.Page.getAttribute("<Month Option Set Field Schema Name>").getText();

// Get Last date of Month
var date = new Date();

var lastDay = new Date(getYear, getMonth + 1, 0);

var lastDayWithSlashes = (lastDay.getDate()) + '/' + (lastDay.getMonth() + 1) + '/' + lastDay.getFullYear();

alert(lastDayWithSlashes);

// Set Last date

var currentDateTime = new Date();

Xrm.Page.getAttribute("<date field schema name>").setValue(lastDay);

If found useful, please mark the answer as verified.

Cheers
Arpit
https://arpitmscrmhunt.blogspot.com

Was this reply helpful? Yes No
Nagaraj M 161 on at

Like (0)

Report
Copy link

Link copied!

Thanks Arpit

I want to create an option set with values from 1 to 10 but it's saying me enter between 100,000,000 and 100,009,999 i have tried to change the same in publisher setting for option prefix but it's also not allowing so how we could achieve this .

please suggest some thing

Was this reply helpful? Yes No
Karsten Wirl 4,477 on at

Like (0)

Report
Copy link

Link copied!

Can you post a screenshot of the error message?

Was this reply helpful? Yes No
Nagaraj M 161 on at

Like (0)

Report
Copy link

Link copied!

I don't think it's an error it's an alert i am getting from CRM side.

Was this reply helpful? Yes No
Suggested answer

Arpit Shrivastava 7,518 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi Nagaraj,

Here is the anwser of your query:

community.dynamics.com/.../127876

Cheers

Was this reply helpful? Yes No
Nagaraj M 161 on at

Like (0)

Report
Copy link

Link copied!

Hi Arpit,

Thanks for reply i have seen that post,

but i want to start my Option set values from 1 , i need this because i want to create Month option set field with values from 1, 2, 3 which will be easy for me to calculate the date value.

any suggestions please

Was this reply helpful? Yes No
Suggested answer

Karsten Wirl 4,477 on at

Like (0)

Report
Copy link

Link copied!

Hi.

Press on "OK" and enter your value... the message shown above is only an advise for you.

Was this reply helpful? Yes No
Nagaraj M 161 on at

Like (0)

Report
Copy link

Link copied!

No Karsten,

It's not advice when i am getting that alert it's clearing my entered data , and saying you must enter in this particular range.

if possible try once and let me share the screen shot whether you are able to enter your own value.

Was this reply helpful? Yes No
Karsten Wirl 4,477 on at

Like (0)

Report
Copy link

Link copied!

Okay, but there is an important difference between your situation and mine.

You are online, I use on-premise.

Was this reply helpful? Yes No