Skip to the main content.

Technology

As the preferred Microsoft Dynamics 365 and Power Platform Service provider, TrellisPoint has the expertise to help your business grow the strategic way.

 

Dynamics 365

Microsoft Dynamics 365, a comprehensive suite of intelligent business applications designed to revolutionize the way you manage and grow your business.

 

Artificial Intelligence

Radically accelerate your productivity with AI features built directly into Microsoft tools and services.

Microsoft Co-Pilot 
copilot365

 
Resources
Connect with Us

Contact Form

Phone: 888.719.0248
Social: LinkedIn Icon 100x100 Twitter Icon 100x100 Facebook Icon 100x100 YouTube Icon 100x100

 

Resources
Connect with Us

Contact Form

Phone: 888.719.0248
Social: LinkedIn Icon 100x100 Twitter Icon 100x100 Facebook Icon 100x100 YouTube Icon 100x100

 

Resources
Connect with Us

Contact Form

Phone: 888.719.0248
Social: LinkedIn Icon 100x100 Twitter Icon 100x100 Facebook Icon 100x100 YouTube Icon 100x100

 

2 min read

Calculating Upcoming Dates in Dynamics 365

Calculating Upcoming Dates in Dynamics 365

A good CRM is about more than just having a sleek system for your employees. It should be a tool used to increase customer satisfaction. Efforts to show that you value your customers go a long way to retain loyalty. This is known as increasing your customer’s “lifetime value”, referenced in this article by Entrepreneur Magazine. One easy way to develop relationships with your customer is to send them an email on their birthday or for an anniversary. Microsoft’s CRM software can easily cater to this strategy.

Date fields in Dynamics 365 are a great way of storing historical information regarding a Contact, Lead, or Account. However, performing date calculation greatly increases their power and allows for more robust data analysis.

Currently, in CRM, you can’t query based on a specific month in the field. For example, you can’t query all contacts whose birthday occurs in the month of October because the advanced find always takes the whole date into account. Fortunately, there is an OOB way around this. This article will explain how to calculate upcoming anniversaries or birthdays in CRM.

Create “Date of Birth” Field

Create a new field on the Contact entity titled “Date of Birth”. The Behavior setting of the field must be User Local, which is why I am not using the OOB Birthday field. The OOB Birthday field Behavior equals Date Only, which will not allow us to do the date calculation necessary

save and close

Create “Age” Calculated Field

Create another field on the Contact entity titled “Age”. This field should be of Data Type “Whole Number” and Field Type “Calculated”. Below is the calculation:

Set Age

Create “Upcoming Birthday” Calculated Field

Create a final field called “Upcoming Birthday”. The Data Type should be “Date and Time” with a Field Type of “Calculated”. Below is the calculation for this field:

Set Upcoming Birthday

Add Fields to Form

After this, put the Date of Birth, Upcoming Birthday, and optionally the Age fields on the Contact form. At this point, copy over data from the OOB Birthday field to the new one via a workflow.

Admin

Potential Use Cases

You can now create advanced finds to show you who in your database has a birthday in the next week, month, etc. You can also build workflows that reference the Upcoming Birthday field and send automated emails to people on their birthdays. Furthermore, you can use the Age calculated field to your advantage by creating marketing lists that are segmented by specific age. You could also use these methods to celebrate upcoming anniversaries of when a client partnered with your business.

For a reference on how to do this customization for CRM 2015/2016, as well as additional information, please refer to this blog post.

Learn more about Microsoft D365

 

Book a Demo   Learn More

 

Solving Business Challenges Faster: Power Platform’s Impact

5 min read

Solving Business Challenges Faster: Power Platform’s Impact

Is your company challenged by trying to integrate multiple standalone tools successfully without making processes even more complicated and...

How TrellisPoint Solves Enterprise Complexities

4 min read

How TrellisPoint Solves Enterprise Complexities

Is your company being challenged with growing pains? One of the most frustrating problems for growing enterprise companies is the need for more...

Close More Deals with Microsoft Sales Copilot

4 min read

Close More Deals with Microsoft Sales Copilot

Is your sales organization working up to its potential? Or is their productivity constantly hampered by lagging data and low-value activities that...