web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer Service forum / Setting a value to a c...
Customer Service forum

Setting a value to a custom date field

(0) ShareShare
ReportReport
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!

I have the same question (0)
  • Alex Fun Wei Jie Profile Picture
    Alex Fun Wei Jie 33,626 on at
    RE: Setting a value to a custom date field

    Hi,

    Please mark my answer as verified if that helped you. Thanks XD

  • sunnz Profile Picture
    sunnz 40 on at
    RE: Setting a value to a custom date field

    Thanks for the help!

  • Verified answer
    Alex Fun Wei Jie Profile Picture
    Alex Fun Wei Jie 33,626 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Customer Service

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans