Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

Get name of next month in Word Template

  • 1.  Get name of next month in Word Template

    GOLD CONTRIBUTOR
    Posted Dec 17, 2020 10:10 AM

    Hello All,

    I have looked everywhere for what should be a very simple task, yet found no answer to this.  What I am trying to do is to generate a Word Doc template in D365 in which I need to display the name of the next month regardless of the current date.  For example, today is 12/17/2020, in my doc template I have a sentence that reads..."If we do not receive the completed paper work by the 25th of [INSERT NEXT MONTH NAME HERE i.e. JANUARY] then we will be cancelling your plan"

    What I have tried so far is using every type of field code I can in the word doc.  Of which I have found several examples of how to get current month and previous months using QUOTE and Set Delay formulas in the field code, but none of these are able to be modified to get NEXT month, each time I try I either get an error or it just shows current month.

    I want to maybe explore creating a hidden field in Dynamics that calculates the next month, but have not had much luck with that either, as I only want the month name, and not a date.  Does anyone out there in CRMUG land know how to accomplish this seemingly simple task?

    Thank You,

    Lance



    ------------------------------
    Lance Day
    MVP Healthcare
    MS D365 CE Admin
    PA
    ------------------------------
    Digital Acceleration Binge Day.  January 28th 2021 | 11:00 AM - 2:00 PM EST


  • 2.  RE: Get name of next month in Word Template

    Posted Dec 18, 2020 12:49 PM

    You could create a calculated field, start the conditions looking for December dates to generate January then just go month by month as shown.  You would have to redo the conditions each year though. 



    ------------------------------
    Matt Brinkman
    Sr Director of National Sales-Business
    Mediacom Communications
    ------------------------------

    Digital Acceleration Binge Day.  January 28th 2021 | 11:00 AM - 2:00 PM EST


  • 3.  RE: Get name of next month in Word Template

    GOLD CONTRIBUTOR
    Posted Dec 22, 2020 04:57 PM

    Thanks  @Matt Brinkman, I was able to figure a way to do this with using QUOTE in a formula in word though.  Thanks again.



    ------------------------------
    Lance Day
    MVP Healthcare
    MS D365 CE Admin
    PA
    ------------------------------

    Digital Acceleration Binge Day.  January 28th 2021 | 11:00 AM - 2:00 PM EST


If you've found this thread useful, dive deeper into User Group community content by role