News and Announcements icon

Dynamics 365 CommunityForums Customer Service forum Setting a value to a c...

Customer Service forum

Setting a value to a custom date field

(0) Share

Report

Report

Posted on by sunnz

40

Hi there, I've created a form with a date field (Reporting End Date) which is tied to a custom entity. I want that value to default to the last day of the current month. I can't figure out how to accomplish this using the business rules or by creating a calculated value field. Can someone please help?

Thanks in advance!

All responses Img

All responses (3)

Answers Img

Answers (1)

Alex Fun Wei Jie 33,626 on at

Like (0)

Report

RE: Setting a value to a custom date field

Hi,

Please mark my answer as verified if that helped you. Thanks XD
sunnz 40 on at

Like (0)

Report

RE: Setting a value to a custom date field

Thanks for the help!
Verified answer

Alex Fun Wei Jie 33,626 on at

Like (1)

Report

RE: Setting a value to a custom date field

Hi,

use below options, i don't think business rule is able to achieve that.

Javascript

- var lastDay = new Date(date.getFullYear(), date.getMonth() + 1, 0);

[View:https://www.tutorialspoint.com/How-to-get-first-and-last-date-of-the-current-month-with-JavaScript:750:50]

C#

stackoverflow.com/.../getting-first-and-last-day-of-the-current-month

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,431 Super User 2024 Season 2

#2

Martin Dráb 230,503 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans